Hi,
I've set up a database where the primary key of the Company table = the userid. One company per user, so it seemed sensible...
As things stand, the admin user is unable to add Company records. The userid field is invisible on the add form, so when a record is added it is added with userid "admin". Is there any way I can make the userid field visible to admin, so admin can alter it?
I think you're going to tell me I have to do custom forms ....
thanks for any help
Tim Ault
Oxford UK
I've set up a database where the primary key of the Company table = the userid. One company per user, so it seemed sensible...
As things stand, the admin user is unable to add Company records. The userid field is invisible on the add form, so when a record is added it is added with userid "admin". Is there any way I can make the userid field visible to admin, so admin can alter it?
I think you're going to tell me I have to do custom forms ....
thanks for any help
Tim Ault
Oxford UK