1 form many tables??

[paulo_otw]

Hi,

is it possible to have 1 form post data to x number of tables?

I am trying to have a form that lists all of the tasks for a team and then posts the information about each task to the tasks own table.

For various reasons each task ideally needs it's own table rather than have a table per team.


Paul

 

[ejstefl]

Hi,

is it possible to have 1 form post data to x number of tables?

I am trying to have a form that lists all of the tasks for a team and then posts the information about each task to the tasks own table.

For various reasons each task ideally needs it's own table rather than have a table per team.


Paul

Do you need to post the same data to all the tables?

The easiest way would probably be to use and unbound form and put code behind it to update each table. See this thread for an example of using an unbound form to enter data.

 

[Pat Hartman]

For various reasons each task ideally needs it's own table rather than have a table per team.

- This sounds like a design flaw to me.

 

[paulo_otw]

Hi,

Pat I think you could be right as the person who started this has used access less than i have..........

the form in question will look something like:

team XXXXXX
task1 task1-incoming task1-outgoing ---> task1-incoming and task1-outgoing post to table task1

task2 task2-incoming task2-outgoing ---> task2-incoming and task2-outgoing post to table task2

task3 task3-incoming task3-outgoing ---> task3-incoming and task3-outgoing post to table task3


and so on....... I have since had the thought of linking the form to an "new record" table and run an update query to update the individual tables.....would these be the easer way round the problems?
Paul

 

[jason_lee]

Hi, Paul

Almost everything can be done with VBA code in Access, but for this case, I think Pat is right, the design "each task ideally needs it's own table rather than have a table per team. " looks like a flaw, and then it leads to the problem you posted. So talking about why you choose that design may be better, if we can find another way to replace it suitably, the question you asked may disappear.

regards