Recent content by Wull

Ahhh, seems I was looking at that back to front. I thought that for customer details entry the form would be first then any further queries run from the form. Looks like I need to rethink my understanding of Access. Thanks for the pointer.

Is it because I haven't included the foreign key that this is happening? When I include the field City_County_ID in the Customer table during the creation of the form it seems to function ok with no error messages from the wizard. At the moment the only solution I can see is to include it...

I thought I had managed to get my head round the basics of Access but something, and probably not the only thing, has me stumped. I have stripped it right back to basics so that I am looking at a part of the data in its simplest form. Two tables, Customer and City_County. Customer: (PK)...

I see what I was doing wrong now, I was trying to create a multi value look up from one side of the junction table to the other when I should have made it in the junction table.

lol, fair comment. I was just hoping there would be an easy way of creating a unique identifier that was a little more than the 1, 2, 3... format.

In Access 2007 how would I have a table create customer IDs that include letters. I am aiming at having the first 2 letters of the first and surname used. For example; John Smith joined 1st Jan, ID = josm001 Joanne Smith joined 2nd Jan, ID = josm002

That makes a lot of sense, thanks for pointing that out. I'll make that change when I get home from work. I was getting a bit lost lastnight with that junction table. I want to create a form that allows staff to enter customer details, in that form I was looking to create a selection of check...

Hello all. Can someone tell me if I am doing this right. I have very limited knowledge on databases. I am putting something together for an institute that hosts various types of events, comedy, venue hire, music and exhibitions being examples of some of the things they do. I have created an...