Form from many tables

[posfog]

Hi All and Festive greetings!

I have started to create a database with a number of tables for different types of data that is required and started to build a single table to allow a user to enter the details.

Within this form i have used the Tab control so i can split the different areas and have the sections from each table on a different tab.

I have put the relationship associated to the ID number and remembered that if i want all the data collected from the different tables in one area that i believed i needed to right a single query.

So after doing all the above and putting in some test data from using the single form i ran the query and get nothing apart from the headers from all tables but nothing is showing as far as data.

Could some be so kind in saying where i have gone wrong?

Regards

 

[posfog]

UPDATE - I just removed the relationship within the query and it is kinda working now apart from in the query is doubling up on the data as in its putting in three lines of the same data?

 

[Trevor G]

In the query add a group and then change one of the fields to show first that should hide duplicates, if that doesn't work go to the query and select SQL view and copy the code into your thread that would help getting a solution.

 

[posfog]

I think i have sorted by fluke luck more than anything elese but thanks for the input Trevor and its nice to see someone local to me!! Even if you are a city supporter

 

[Trevor G]

Thanks for letting me know.