Well if visit doesn't need an ID, then how would you create the relationship?
I figured it would need to have a serialized document on each entry so it knows its place, making it the PK
I clicked all three fields in the tblVisit and made them primary keys, so now I just need to make the relationship to work,
I never knew I could do that in access with the multifield PK. Thanks for that.
I'm guessing thats SQL coding? or some kind of variant of that?
ok, I get that I'm creating 3 tables,
PK In Customers is ID (Autonumber in Access)
PK In Dealers is ID
Visits would be the intermediary table using the ID from Customers and Dealers as foriegn keys?
As of now I currently have...
Well I'm pretty rusty on the concepts of many to many relationships, but I'm assuming thats what I want to create for this situation.
What I'm creating is a database to track customers that enter my place of buisness. So far so good, but what I'm having issues with is 2 of the major things...
ok,
well looking at it, it shows correctly inside of firefox but in internet explorer it doesn't show at all.
Could there be something in IE that doesn't allow it to show correctly?
I have a windows 2000 machine in my domain and I've checked the firewall settings and it is not displaying a certain page.
It works for me from my machine but I know my machine has unaltered access to the internet.
Ive checked through the banned destinations and the page is not in that, and...
Ok,
I read through the office kb article about adding in
' If the form contains user-defined fields, you can use
' the following syntax to transfer the contents of a
' user-defined field (FieldName) to Word:
' strMyField = Item.UserProperties.Find("FieldName")
' oDoc.FormFields("Text3").Result...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.