Last post Oct 09, 2008 02:31 AM by Mikesdotnetting
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.
Oct 09, 2008 02:31 AM|Mikesdotnetting|LINK
Are you talking about setting this up in an Access Form or similar, or are you talking about how to do this in a web page using ASP.NET? If your are talking about Access Appliocations, you would be better off asking in an Access forum or newsgroup, such
as http://www.utteraccess.com. ASP.NET knows nothing about the forms or reports in Access.