Relationships

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

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 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
Click to expand...

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]
 
Back
Top