Forms' Record Source

[Progress2007]

Hi

I have a form which has 7 tab buttons. There is one more main form which contains Add button. There are 7 diffrrent tables for each tab controls, relatiing with ID's

When some one clicks on add button then i will opne my form which contains 7 tab buttons.

Now i want that data can be popultaed for a new ID and i could save that data into 7 diffrent tables for a single click.It menas i have to assign a record source for this form that will contain all 7 tables fields.

I am trying to use Record source as s query but could not able to save or enter data into this form.

Will u great guyls provide me some code snippets to do this.

[RuralGuy]

Are you saying you have 7 tables all related in a 1:1 relationship?

[Progress2007]

Are you saying you have 7 tables all related in a 1:1 relationship?

yes sir

There are 7 tables all tables have there PID's

[RuralGuy]

1:1 relationships are not very common and it is very unusual that you have 7 tables set up this way. You may want to review the design before proceeding.

[Progress2007]

1:1 relationships are not very common and it is very unusual that you have 7 tables set up this way. You may want to review the design before proceeding.

Ok sir. Tell me one thing if i am ignored 1to 1 relation ship.

Now as i have just one form which has 7 tab buttosn.

I want to get and save data to all seven tables ...how can i do this

[Progress2007]

Ok sir. Tell me one thing if i am ignored 1to 1 relation ship.

Now as i have just one form which has 7 tab buttosn.

I want to get and save data to all seven tables ...how can i do this

One more thing suppose We have to Create a Health application.
First is detail section

First tab is Detail of that Person.
second tab is Contacts
Third tab is abt Insurance
Fourth tab is Scheduling
and so on.........

I can not include all the data into one table......for the sake of normalization......

Please tell me how can i do this...........

[RuralGuy]

I would think that at least scheduling would be a 1:m relationship. It is not likely that you would have changes that affect all 7 tabs of your form at the same time. If you do then there is probably a problem with the design. Assuming each tab has a SubForm on it that is bound to a table through a query, then each tab will take care of itself and save when it needs to without any assistance needed from you. That is what bound forms are good at.

[RuralGuy]

I did not intend to be stubborn and stop the conversation, but simply understand how you had constructed your form. There may be a much simpler solution.

[Progress2007]

I did not intend to be stubborn and stop the conversation, but simply understand how you had constructed your form. There may be a much simpler solution.

Hello sir

As i earlier mentioned that i have a form which has 7 tab buttons...
Now i can not createte sub form for each tab due to time constraint and some other req. ...

so please suggest me a best possibel way....

[RuralGuy]

I have no solution other than having a SubForm on each tab. I believe you have a problem with your design that will continually complicate whatever you try until the basic design is revised.

[Progress2007]

I have no solution other than having a SubForm on each tab. I believe you have a problem with your design that will continually complicate whatever you try until the basic design is revised.

OK sir...With your advice i have created form for each tab. Now Please provide some guidance to me , how could i can bind these forms with record source...

[RuralGuy]

Don't you have a RecordSource for each form? Doesn't each control on each form have a ControlSource?