I’m building a database for work and it works pretty well.
I’ve just one small problem with linking field on 2 tables in a one-to-many way.
I’m linking 1 record from table1 to many records on table2. Works great.
On table 2, I desactivated the multirecord link so I can only link 1 record form table1. Great again.
The problem is that from table 1 I can make another record which link to the same record on table 2. So when I look in my second table, in my “single record link field” I still end up with 2 differents records from table1 !
So what I would need is to be able to link multiple records from table1 to table2 but without being able to record 2 time the same one.
Any idea ?
Thanks you for this wonderfull tool !