Relationship incorrectly setup

[markswan20]

I've not used any relationships before as i know nothing about them i have tried putting all my information on one table but have run out of columns.

If i have 2 identical tables saved under different names and i'm looking at putting product1 and product2 from both tables on a form what relationships do i need to set in order to do this?

I have tried i got past the form wizard saying you need to edit your relationships but when i look at my form it's all greyed out and my 2 fields are no where to be seen.

Kind Regards
Mark

 

[Trevil]

In the simplest terms, you can create a query to join the two tables, then use that query as the source for your form. i.e.
SELECT table1.product1, table2.product2
FROM table1INNER JOIN table2 ON table1.product1 = table2.product2;

If my suspicion is correct and you have created a second table so you can have more columns, then use whatever unique key you have defined.

You're on your own trying to maintain the integrity between tables.

"Hmmm, it worked when I tested it....

 

[PHV]

Have a look here:

http://r937.com/relational.html

Having more than 255 columns in a single table seems like a normalization issue ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[markswan20]

Thanks for your replys guys.

I have linked a few test fields together to try and solve my problem. I can now add the fields to my new form from the 2 diferent pages but only the information from the 1 table is showing. I have tried using a query and running the form from that but it does the same what kind of relationships do i need between the two to enable the information to be correct.

Apologies if i've confused anyone as i've confused myself

Kind Regards
Mark

 

[TheAceMan1]

How are ya markswan20 . . . . .

Have a look here: Normalizing Tables Table Relationships

See Ya! . . . . . .