View data from 2 tables in 1 Layout.
I have designed 2 tables and have problem in dispalying the data. How to make 1 form that can view data from 2 tables.
You really have to provide more details to get help.
What are the two tables you have and what do you want to display on the layout?
I got 2 tables : vot and expenses
field in vot :
fields in expenses:
Relationship : I'm using 2 fields which is year & vot_no
I have created 1 layout to display :
which are in different table. So how to do that. I have tried but only
data from 1 table are displayed (table expenses)
Thank you for your post.
Go into the Relationships graph in "Manage -> Database", and make sure the "year" and "vot_no" fields in "vot" table are linked to the proper two fields in "expenses". Once that is set up, you should be able to view the data properly in the current layout.
Make sure the values are the same in both tables. Otherwise, the link may not link to the other table, and therefore, only information from the current table will display.
Relationship : I'm using 2 fields which is year & vot_no If those two fields are from the vot table, which fields are they matched to in the expenses table?
If those two fields are from the vot table, which fields are they matched to in the expenses table?
Thank you for your reply, I got the idea. Now, data from 2 tables can be view in one layout but in different manner, not simoultenously. Meaning that, data from table expenses is display first and when I enter vot_no, then data from table year is displayed.
How to get it display at one time?
I'm using same fields name for relationship in 2 tables, like below:
Retrieving data ...