Postby tele » Tue Sep 22, 2015 4:09 am
K, say u have the following DBS: 1st is called "dingbat", will show brand, model, etc, and also 1 of 40 owners. Each owner has 3 to 12 dingbats. Another db is called "service", with repair and maintenance done on each dingbat, and Shows date, time, type of service, job#, etc, and obviously needs to be linked to "dingbat" db, and also requires owner field to id correctly. I had it set up as owner=choice and link worked, but didn't sort "dingbat" correctly, and also was s l o w to edit and select choice. Will end up with 4-7 or so records for each dingbat.
Using your suggestion to move owner to a separate db and link with relation to "machine" will not allow linked owner field to show up in the relation between "dingbat" and "service" dbs. Using an additional link to owner from "service" db will not work, as dingbat needs to be id'd correctly from "dingbat" db.