blomgren Posted February 24, 2005 Share Posted February 24, 2005 Ender replied to this with " You should relate Contact directly to Company by CompanyID, keep the relationship between Company and Location, and add a second table occurrence of Location and relate that to Contact by Location Ref. What this gives you is: A Company can have many Locations. A Company has many Contacts. A Location can be used by many Contacts for a Company. On the Contact layout, you can choose the Location (use a conditional value list to show just the Locations for that Contact's Company.) Then using the Location by Contact TO, show the related Location fields on the Contact layout." And this is as close to wrapping my brain without using a rolling pin. Can you help me in terms of Students Schools Code I have been trying to follow the Invoice InvLineItems Products But this refers back to another DB that would be Contacts. I want my main input page to be my Students file and get a pre-entered School_name and School_code Please forgive me if I am re-posting. I am drowning in a sea of frustration and data! Thank you! DistrictwideDatabase.zip Link to comment Share on other sites More sharing options...
This topic is 6605 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now