sort table field with lookup

[jakobt]

I have created a lookup in a field in a table:
select id, bike from tblbikes.
Column count 2
Width 0,3

When I try to sort the table by bike:
I receive the following error: Type mismatch in expression.

Is there some way to sort a field with a lookup.

 

[spikepl]

There might be. But lookups in tables were invented by Beelzebub. And he's ROTFLMAO right now. So drop them in tables. Use them in forms.

 

[jakobt]

Would you then only have the ID to the referenced cell. (Istead of a lookup to a more descriptive field which you can identify easier.

 

[Galaxiom]

Would you then only have the ID to the referenced cell. (Istead of a lookup to a more descriptive field which you can identify easier.

1. Tables don't have cells.
2. Tables are for storing data, not interacting with it.