Uncertain About Relationship

[Robert Snow]

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.
Edit Relationship
Table/Quary BLD
Related Table/Quary BLD
Enforce Referential Integrity (Box Checked)

Join Type
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.

 

[eselk2003]

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 databasefile.
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.
Edit Relationship
Table/Quary BLD
Related Table/Quary BLD
Enforce Referential Integrity (Box Checked)

Join Type
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.”

Not sure why the join properties would change back to 1 like that,
maybe someone else can help you with that part. Maybe just leave it
as 1 in the relationships screen, and then change it to something else
in your form datasource or query. When you create a query (or form)
you can set a different join type, and I know in that case I have
never had it change on me.

Not sure if this is clear. What I'm mostly trying to make sure you
know is that you don't have to set anything in the relationships
screen if you don't want to... you can set the relationships when you
create each query if you want/need. It is nice to set them in the
relationships screen, that way when you create a query it defaults to
the correct joins for you, but you can also just set the relationships/
joins when you create your form/query.