Form

[tzvi]

In my database i have a customer table with all customer information (name address etc.)


I also have a table of jobs, wher the job# is uniqe and it says the job information that i did for customers.

I want to have a form with the customer information,
in addition i want to have on the same form in the bottom another list of all jobs that i did specificly for this customer that i have his record open now.

can anyone tell me how to do it?

Thnak you in advance!

[June7]

See if this helps you http://office.microsoft.com/en-us/ac...010098674.aspx

You could also build a report that would show the data.

[tzvi]

See if this helps you http://office.microsoft.com/en-us/ac...010098674.aspx

You could also build a report that would show the data.

thank you!
It basicly looks like a good article for me.
I will look in to it!