PDA

View Full Version : Input data in master/detail


skwilliams
04-28-2005, 07:33 PM
I have an MS Access DB with a main table that contains a quote number, name, address, etc. and a sub table that contains a quote number, Item number, qty, price. These tables are related through the tblMain PK and tblSubMain FK(which is the field quote number).

I need to create an input form in ASP for this data. I had no problems creating the input form for the main table, but the input form for the sub table is a different story. Since the detail input form can contain multiple records I need to be able to add many items to one quote.

Does anyone have any ideas?? I've found info on Master/Detail records throughout the Internet. However, they all seem to relate to existing records, not new ones.