Input Master/Detail data

[skw8966]

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.

 

[traingamer]

Just create an input page / form to add ONE record at a time. After creation return to master page, with new record added to display.
e.g.
Master record .........

Detail one Edit
Detail two Edit
Detail three Edit
Add new record

where each edit link goes to an appropriate page and the 'add' goes to a new entry page / form.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill