Relating sub sub forms

[skwilliams]

This is an update to a previous post which was not completed.

I'm developing a quoting database with various tables and forms. Form1 is for inputting a customer's information, quote number, etc.. Form2 is a tabular subform on Form1 for inputting item information (description, pricing, etc.) and Form3 needs to be a tabular subform within Form2 for extra charges relating to that particular item. Currently, Form1!pkQuote and Form2!fkQuote are related in a One to many relationship. Form2 also has a primary key of pkAuto (set to AutoNumber).

How can I relate Form3 to Form2 the same way, as Form3 can have many records to Form2's one record?

What is the best way to setup the sub sub form?

 

[skwilliams]

Thanks for the advice.

That certainly gives me more insight into this issue.

Steve

 

[smed]

This site might also be useful :

http://www.mvps.org/access/forms/frm0031.htm

Smed