Access Database Relationship Problem
Another Access question! Within my database I have three tables (customers, products and staff). The fields in these tables are all formatted as 'text' apart from the ID field (the primary key), which is formatted as 'AutoNumber'. There is a fourth table (orders) which take data from all three tables in the form of drop-down menus/lookups. The problem is, when I use the Lookup Wizard to create these drop down menus it automatically changes the field format from 'Text' to 'Number/Long Integer', and doesn't let me change it back to 'Text'. This presents a problem as the data has to be in the same format in all of the tables.
Does anyone know how to change the format back to 'text' without destroying the relationships?
Thanks,
Ox