Table: Fields
Fields: FieldID Autonumber
TableID Number
ProjectID Number
FieldName Text (50)
DataTypeID Number
DataLength Number
Query:
insert into fields (tableid, projectid, fieldname, datatypeid, datalength) values (1, 1, 'Table #1 Field #1', 1, 50)
What's wrong with this? I'm stumped.