> > I'll try adding the format to see if that helps. I was using 'database >>> administration' so maybe it's not using a SQLFORM there. >> >> Yes, appadmin uses SQLFORM and should show the dropdown as well (but only if the referenced table has a format specified or you add the validator manually).
> I don't know what is going on... the dog and person tables work, but the > customers and contacts tables do not. > This is strange -- you can create the customers table by itself, add and query records, but if you then try to create the contacts table with a reference to customers, it gives you an error saying the customers table is invalid? I'm not sure what to make of that. Anthony