Queries derived from Tables: Intepretation

[adrift]

I'd asked a technical support person for some help and they forward me the following text:

In the desktop database, create two views (a.k.a. "queries&quot, FOO_A and FOO_B, both built on top of FOO. The FOO_A view (query) would have four fields:


OID - derived from OID_A
Name - derived from Name
Age - derived from Age
TIMESTAMP - derived from TIMESTAMP_A


The FOO_B view (query) would have four fields:

OID - derived from OID_B
Name - derived from Name
Age - derived from Age
TIMESTAMP - derived from TIMESTAMP_B

What I'm not sure how to do is create a query with a field name "derived" from a different field in a table.

Such that when I open the query, the variable name is OID but the data is from OID_A or OID_B

 

[adrift]

also, the table structure is

FOO

OID_A OID_B Name Age TIMESTAMP_A TIMESTAMP_B
----- ----- ---- --- ----------- -----------

 

[grnzbra]

What was your original question?

 

[adrift]

It relates to being able to sync multiple handheld devices to the same table without collision.

This is the solution, I just need to know how to implement it.

 

[grnzbra]

It seems that in each query the top line of the query grid for OID field would be:
OID: OID_A
or
OID: OID_B
depending on which query you are in

in the SQL statement it would look like:
SELECT OID_A as OID

 

[adrift]

Brilliant.. so simple but I couldn't get it. Thanks!