Oct 06, 2008 10:54 AM|amerifax|LINK
I have a master database called permit. It has all the builders that built homes in Wisconsin in past years. It only has one number that has builder information “BLD”. That is the reference used in the builder database file.
It’s called “Builder”. It has a reference called “BLD”.
I want to link the “Permit” file to “Builder” file to run lookups. My first job, as I see it, is to develop the “Relationship’s”. Builder has all the phone, address and more for every builder in the “Permit” database.
Please try to understand my use of database or files. Access seems to call it a bit different, I will get it down in the future. My terms are more Visual dBase.
Database or file or “Permit”, Reference is “fields ”bld”
This is my first atempt st the Access relationship. How do I look?
Relationship Permit-bld to Builder-bld.
Related Table/Quary BLD
Enforce Referential Integrity (Box Checked)
2. (This was my thought)
When I went back in by clicking on the line between “Permit and “Builder” there was a change.
The “Enforce Reference Integrity” box was blank.
The “Join Properties” was changed to “1.”
My objective is to be able to use a form with the “Permit” file and see difference values of the “Builder” file that relate to the “Permit-bld” builder that is current selection.
I tried hard to explain. I hope you got it. Must times the question is harder than the fix.