Please be patient with me as I am a noob.

I am trying to link tables using the foreign key but I am not sure how to do it in this platform.

OK, stop laughing. I have looked all over this forum and have not found an answer or a How To Manual.

I appreciate the assistance.

SDM

Sorry ...thought I had figured it out but I was unsuccessful. Any help would be sincerely appreciated.

Hi and welcome!

1. Ok so lets say your tables are called table1 and table2 and you have an id and title for each.
2. Table1 is your main table, table2 your secondary table containing related records for each in table1.
3. Add a field of typeForeign Key to table 1 and call it Foreign.
4. Once you've saved that field, you'll notice a box in the foreign table column of your fields grid with a broken line (- - - - ).
5. Drag table 2 from the tables list on the left into this area.
6. Now, when you add a Page (layout) for table1, drag all of it's available fields to the layout, you'll be able to edit the properties of that field on the layout to select which related field you want to be displayed as it's labe - for example, title. This will store table2.id as the value but display it's title.

Hope this helps!

Gez

Thank you very much!!

Check it works before you thank me LOL

Works great. The only thing I don't see the the visual connection between the tables.

You can see the ERD in the projects tab by clicking database - I think.

Glad it helped!

Gez

A simple refresh took care of it.

Great!