Assuming I have 2 tables
Table1ID (for table relationship)
I want to create table 2 programatically
CREATE TABLE Table2
IDAUTOINCREMENT PRIMARY KEY,
Table1ID INTEGER NOT NULL CONSTRAINT FK_Table1ID
REFERENCES Table1 (Table1ID),
this is creating the relationship but the display in the table is the ID from table 1, how can i change that to be the "Name" field in Table1 like when i do it from the wizard in Access?