subforms

[dudezzz]

This is a question from yesterday that a member had helped me out with.

I have additional questions while I am waiting for response from him. If anyone of you can help, I would really appreciate it.


1. How can I make a form that gathers information from multiple tables?
2. Lets say it is possible, how does this info get saved to these multiple tables when the user clicks on the next record button on the record navigator.

Thanks for the assistance!

 

[dudezzz]

that works, However....

I have Form1 that contains a field from Table 1 and another field from Table 2. So I wrote a query to collect these 2 fields and based the form on this query. It works! thank you.

Now, what if I want to include a 3rd field from a 3rd table whose value is dependent on the value that was selected on Field 1 (from table1)?

If I sound confusing, please let me know I can send my actual db and we can start our discussion. (there is more on this I want to accomplish today...but not able to due to my lack of knowledge)

thanks everyone for helping!