Multiple Tables into one form

[jknight]

Hello,
I am fairly new with Access and was working on something need few questions answered. Appreciate all answers/feedback.

I have one form (Request Form) which has quite bit of information on it. So I decided that I would need the following tables:


tblRequests
tblCustomer
tblSalesperson
tblSupervisor

I think I have created the relationship fairly well. Most of them one-to-many . Suggestions/input is welcome on these as well.
I created the form but now I whenever person is making entry I want the information from one form to go into multiples tables. What's the best to go about this?

I have tried couple different ways, Made a query from the tables and then using that as Record Source for the form as well. It doesn't seem to work properly. Please help. Thanks

[June7]

What information needs to go into multiple tables?

In creating a new Request record, need to select customer and salesperson? Use comboboxes.

Possibly you need form/subform arrangement. http://office.microsoft.com/en-us/ac...010098674.aspx

[jknight]

One table just has information about the customer. Such has name, address, telephone, etc.
The second table has information regarding the Request, such as date of request, what type of requests,
I created the third table for the salesperson info such as names, telephone, department name, manager.
I also need to keep track of payments history related to the Requests, if the customer is making payments.

Am I going in the right direction?

[June7]

Yes. Also review
http://forums.aspfree.com/microsoft-...es-208217.html
http://www.developerbarn.com/communi...-database.435/