Linking forms by buttons

[Andren]

Hi all.

I am STILL struggeling with my litterature database.

It is now structured in a "one-to-many" fashion,containing a "Main" table and many other little tables (T1,T2...Tn).

In the Main table I have "ID" as uniqe identifier for each reccord. It also contains link-fields for each T-table (T1_ID,T2_ID... etc), In each T-table I also have an ID.

Based on the Main-table I have created a Form and on this I have placed
a Tab-control. In each Tab-page I have sub-forms for each T1 ...Tn - table.

In one instance I need to feed so many T-tables with information that there
is no room left on the Tab-page for all sub-forms needed.

Then I put buttons on the tab-page to open a form like a "pop-up-form".

AND - Ladies and Gentlemen - here is my very stupid question:

How can I synchronize the "pop-up-form" to the current reccord on the main forms tab-page, so that users feed info into the correct reccord????

HYUT (Hope You Understand This).

PH (Please Help)

/ Anders


.

 

[neileg]

I've read your other thread where you describe going from a flat file to a normalised structure. However, it sounds as if you've gone wrong here if you now have so many tables that you can't get them on your form.

However, to answer your question directly, you should base your pop-up form on a query that has as a criterion, the name of the control on your main form that holds the ID. For example
Forms.frmMyForm.ctlMyID