If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships
I have 2 tables in a data base with a relationship
defined beteen 2 fields eg: FAMILY ID (AUTONUMBER - PRIMARY) related to FAMILY ID (NUMBER) I have a LOOKup box to lookup the LNAME, but I want the records to be looked up in ALpha order eg ADAMS, BELL etc. but the records are not in alpha order. How can I correct this and still retain the Relationship. Thanks for any help |
#2
|
|||
|
|||
On Tue, 15 Mar 2005 17:40:04 -0800, "Roger"
wrote: I have 2 tables in a data base with a relationship defined beteen 2 fields eg: FAMILY ID (AUTONUMBER - PRIMARY) related to FAMILY ID (NUMBER) I have a LOOKup box to lookup the LNAME, but I want the records to be looked up in ALpha order eg ADAMS, BELL etc. but the records are not in alpha order. How can I correct this and still retain the Relationship. Thanks for any help I'd suggest that you NEVER use the Lookup field type; and in fact, never use table datasheets for anything other than debugging. Use a Form instead. Creating a Lookup does create a relationship, but it's neither the only nor the best way to do so; the Relationships window works just fine. On your Form you can have a Combo Box based on a Query on the table containing the names; this Query would be sorted by lastname to make the combo box show names as desired. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 06:03 AM |
Deleting Relationships... | Kojones | General Discussion | 3 | December 18th, 2004 12:46 AM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 09:31 PM |
Disappearing relationships | Dan | Database Design | 2 | August 6th, 2004 06:43 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |