Hi All,
     I have a table to the right, which is in a subform, which contains data that was inputted via a different part of the program, I want to show the data in the table within the sub form at this point it shows nothing but I know there is data in there.

Any help?

Paul D

[quote author=BOBSCOTT link=1181802834/0#1 date=1181830862]Is the data in the subform naturaly or relationaly linked to the main / parent  record you are looking at when no data is in the subform?

[/quote]


It is naturaly linked.

Hi BOBSCOTT
I under stand that, I think i might need to make myself a bit clearer, I want to enter data into a different Form (Merchant_Information), and not have to exit the app, and then go to another form (Plantrak) within the same database, and on that form contains the subform (Merchant_Information) which is in table form, and shows all of the data.


Thanks in advance.
Paul D

BOBSCOTT wrote on Jun 14^th, 2007 at 9:18pm:



Thats ok BOBSCOTT, thanks for the help I am going to read up on the "relational method" now

Paul D

drastixnz wrote on Jun 17^th, 2007 at 11:36pm:


We'll need more information: are you naturally or relationally linked? In either case did you enter some records in the subform? If so, where did you enter the data - with the subform "standalone" or with the subform appearing on its parent?

Yes there is

I want all of the data to be shown, I have used Natural links but the data does not show.

I enter the data into a form called Plan Tracking Log, I save the information and scroll past into a blank record.

Then I open another form (Plan Tak V0.2) it has "Plan Tracking Log" as a subform table in it the data does not show there.

drastixnz wrote on Jun 18^th, 2007 at 6:59am:

You will need to use "/=" in the key field on the main (parent) form, to see all the relational subrecords in the subform.

Just some background on this query to give more of an overview about the overall purpose of what we're trying to achieve (Drastix & I collaborate on some work and this is one of them)

"The Table View on the RH side of the page will show a Merchant Name, Merchant Reference, Job Number, Job Name, Job Address, Job Street & Job City. Because it is easier to overview and interpret the information in a table and because of the variety of quick searches we do, we've chosen this type of view and there are only 2 types of activities that can occur on this Table.

1) Select/highlight a record (and the resulting data for editing purposes is shown in a tabbed layout for the Merchant, or the Job Details, etc, on the lower LH side so that pull-downs, combo boxes et al are available plus good control of the data entering the database(s) is exercised) and
2) command buttons are available immediately above the Table View that changes the sort order of the records shown. eg. Default sort is by Job Number but it is also possible to sort by the name of the Merchant or by the Merchants Reference, Street, City, etc etc and the columns will shift depending on which is the primary sort order.
At no stage do we want to allow the user any data editing capability in the Table View even though this possible. We will program to stop that so that any data changes can only be done on the tabbed forms that relate to the record selected in Table View.

Just so you're aware, in the middle LH side of the screen are command buttons that restrict or expand which records will be shown in the RH Table View.

Each button that restricts records will change to a different colour when in force so the user is aware of what restrictions are, or not, in operation. This will allow multiple types of record selection criteria. They will operate on a toggle basis so they need to be clicked a second time to deactivate."

SRKTRY