multiple control sources for a form

[trixxnixon]

is it possible for a form to have multiple tables as a control source?
i tried to search the forum, but the search function is not working for me.

[nico5038]

Depends on what you want to do. When all tables have the same fields it's no problem to switch "dynamically" from using, but in general it's no good idea to do this.

Can you elaborate on the reason why you want this ?

Nic;o)

[trixxnixon]

i have decided to nix the idea i was working on and instead have the current form open a seperate form, which changes my question.

this is a request database, where there are forms for the clients and forms for the employees that process the request.

then client form generates the unique request tracking number and the employee side calls for the tracking number input to display the information.

these requests can be pended for approval multiple times. I have created a seperate table for storing the request tracking number(foreign key 1 to many) generate a unique pending entry number(primary key) with a pending start date and a pending end date, as well as a comment box for pending reasons.

in addition to the fields, i would like a section to display every pending record for the specific requests tracking number.

have any ideas on any aspect of this request?

[nico5038]

I guess the best advise I can give is to check the sample databases that come with Access. Just select new database and select the samples tab.
There are multiple samples for tracking all sorts of objects.

Just pick the best fitting form design and use that for your database design..

Nic;o)