Tab Control Data

[Keiath]

I have a form with a 3 page tab.

1st Tab Data comes from table 'Site Data'
2nd Tab from another table 'Fin Data'

both tables are linked in a relationship by the 'site number'

Tab/Table 1 has 12 records
Tab/Table 2 has 1 record

When I open the form instead of all 12 records showing its only showing 1 record
the record where there is data in both tables

I need it to show all records from table 1 regardless if there is data in table 2 or not (has financial data may not be available for a site)

Hope that makes sense please help

 

[apr pillai]

I think you need to check few things and make corrections, if necessary.

1. If 'site number' Field in Table2 defined as Primary Key then change it as ordinary field. Let the relationship remain as it is.
2. Design a separate sub-Form for 'Fin Data' and insert it on the second Tab.
3. Set the 'Link Child Field' and 'Link Master Field' with 'site number' field names on respective properties.

 

[Keiath]

I think you need to check few things and make corrections, if necessary.

1. If 'site number' Field in Table2 defined as Primary Key then change it as ordinary field. Let the relationship remain as it is.
2. Design a separate sub-Form for 'Fin Data' and insert it on the second Tab.
3. Set the 'Link Child Field' and 'Link Master Field' with 'site number' field names on respective properties.

This is fine but the problem is i dont want it to appear as a subform as I need a layout as there is a lot of information.

The only way I could work out to solve the problem was to ensure each site number is on table 2 and every record in table 1 has data in table 2 eventually, i was just hoping for a cleaner way

Thanks for your help anyway

 

[RainLover]

If you are using a Query, right click on the Join line and select Join Properties.

You will see that you have three choices.

Both Tables Equal.
All from one and Matching from the other.
All from the Other and matching from one.

So in my opinion the query has the wrong Join, which does not necessarilly have anything to do with the Relationships.

 

[Keiath]

If you are using a Query, right click on the Join line and select Join Properties.

You will see that you have three choices.

Both Tables Equal.
All from one and Matching from the other.
All from the Pther and matching from one.

So in my opinion the query has the wron Join, which does not necessarilly have anything to do with the Relationships.

I am not using the query method, i am a bit of a noob so not sure how to use this method

 

[RainLover]

Post your SQL

BTW Are your forms bound.