Joseph31 Posted February 10, 2005 Share Posted February 10, 2005 Ok, I have looked at some of the questions / answers relating to this and they helped me but not all the way... So This is what I need to do: I have already Setup -- a table "Broker" that is linked to a main page [relationship] Mainid --> RelMainid. On this broker page I can enter all of his information [address phone etc...] There is a pull down list on the main page -- the list gets indexed from the "broker" page. What I would like to do next is make a submenu pull down that will have only contact name that relate to the broker listed in the first pull down. This contract should have all of there own information like notes and email address. How should I set this up --- should I put the subcontact info on the same page as the broker page or some where else. Help? Joseph Link to comment Share on other sites More sharing options...
stanley Posted February 10, 2005 Share Posted February 10, 2005 Joseph: If you can create a relationship based on the data in the first value list, then you can use that relationship as the basis for a second value list, in a second field, which would be your "sub value list." For example, if you are relating to a contact list, and your first value list has all the types of contacts ("vendor", "subcontractor", "client" etc), AND there is a field in your contact list with that data, then you can make a relationship between the two fields, and make your next value list be (for example) the names of the related contacts. -Stanley Link to comment Share on other sites More sharing options...
Joseph31 Posted February 10, 2005 Author Share Posted February 10, 2005 I get that... I just do not know how to do it... or where to put the subcontract names and there information... Does it go in the same table as the primary or do I make a new Table.. Joseph Link to comment Share on other sites More sharing options...
-Queue- Posted February 10, 2005 Share Posted February 10, 2005 It doesn't matter. The choice is yours. Link to comment Share on other sites More sharing options...
stanley Posted February 10, 2005 Share Posted February 10, 2005 Joseph: The answer to that really depends on what, functionally, you are trying to do. -Stanley Link to comment Share on other sites More sharing options...
Joseph31 Posted February 10, 2005 Author Share Posted February 10, 2005 Ok, That ones my fault... Let me re-explan I already have a broker company pull down -- from another table What I need is another pull down that will only show names from the first pull down. All of the expamples require me to do everything over -- this will mean going back through 1000 records and selecting the broker compaines all over again. Do my question was how do I make a 2nd pull down show only names that belong to the broker company of the first pull down. Relationship already inplace Main::Mainid --> Broker::RelMainid Thank you Joseph Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7020 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 accountSign in
Already have an account? Sign in here.
Sign In Now