Create New Table From Oracle ODBC
Create New Table From Oracle ODBC
(OP)
I have setup a table in Access that when the switchboard form opens, it deletes all records and updates the table with current information. It works find. My only problem is that my index (Employee Number) is supposed to be unique, but there are two records out there that are duplicates because the staff person is covering two positions.
The table is based on a query. How do I get the query to skip the duplicate records, based on the employee number?
Thanks,
Basia
The table is based on a query. How do I get the query to skip the duplicate records, based on the employee number?
Thanks,
Basia
RE: Create New Table From Oracle ODBC
Unique Record: All fields in that record is compared against others for uniqueness.
Unique Value: All fields selected in the QBE grid are compared against other for uniqueness.
If you need more help, try looking up Unique Values in help.
Joe Miller
joe.miller@flotech.net
RE: Create New Table From Oracle ODBC
RE: Create New Table From Oracle ODBC
Regards.
Joe Miller
joe.miller@flotech.net
RE: Create New Table From Oracle ODBC
Basia
RE: Create New Table From Oracle ODBC
EMPTABLE
EmpID Long Primary Key
EmpName Text
POSITION
PosID Long Primary Key
PosName Text
EmpID Long Foreign Key
This implements a one-many relationship using proper relational design techniques and prevents you from writing special code, looking in a single field, and managing the result uniquely.
Steve King
Growth follows a healthy professional curiosity