linking two unrelated rows

[nsw2206]

Hi all,

 

in one table I have my database tables and fields listed.

 

in the other table I have some form field names extracted from fillable pdf. (thanks itext and 360works  

 

how do I make a layout that I can show these unrelated tables, chose a row in each and have a button to click and make a record in a third table that keeps the association from one row in the pdf table to the database field I want to fill it with.

 

showing the unrelated tables - cant use portals.. got me baffled. making a button, not so hard

 

thanks in advance 

[comment]

make a record in a third table that keeps the association from one row in the pdf table to the database field I want to fill it with.

 

It sounds like this will be a one-to-one association, will it not? If so, you could define an auxiliary relationship between the two tables using any pair of fields and the x relational operator. Then place a portal based on this relationship on the layout of one of the tables - it will show ALL records from the other table. I believe the button should set a field in one table to the unique id of the record in the other table. A third table is not necessary.

[nsw2206]

{reads about x relation} ah that looks good. thanks I'm such a newby.