Search results

Ah yes, that solved it. If I have the other ID's in the maintable though, does that mean I will need to manually add the relative ID to link the tables? Anyway, database attached if somebody would kindly look over it to see how I'm doing. Thanks.

Ok, I have added the fields to the tables that are being used here. The Data table is just for lookups and has no repeating values, and the Saundries and Supplier tables are not linked in any way to the other tables and also have no repeating values. There is one thing however, in the...

Just a quick thought, I've started laying out the tables in Access 2000 and I have added the tables to the relational window. Question; can I use the primary key for the maintable to link three other tables for the foreign key? See attached image.

Ah that could be a problem as each item would have a minimum of three images! Although I could code the database in regular access (97 is it?) for the actual database so I can share it here and get the main thing done and then I assume I can convert it to 2007 in access?? If so I can add the...

Thanks Pat, I thought I had constructed them correcty based on a lydia tutorial but I obviously mis-understood what they were trying to teach, it was a bit technical for a beginner. So if I understand this correctly, the relational database is one HUGE table (not physically of course but in...

Good idea, here is the scrren cap of the relationship tables (others removed as they aren't used in this scenario). I would like to be able to add the item number into the items table and have it automatically add the same value to the tables for finance postal and appraisal. There are no...

Hi Pat, I thought this myself but I don't seem to have that option when I choose 'save as', all I have is .accdb and when I try to save in earlier versions it tells me I can't because of the options I am using in my tables. If somebody cam tell me how to save the database in .mdb I will do it...

Well to be honest I have no idea why I need it to work like this, it just sounded the easiest way. However, if you know an easy way by all means we'll go that route. I've posted the database so you can see where I'm at and you will have some idea of what I'm talking about. There are now 5...

I have a database which relies heavily on a scanned item number (non repeating and NOT a primary key) which needs to be entered into 4 tables, to save time I was wondering if it can be entered into the main table and autopopulated into the remaining three tables? I am very new to access so...

I have a database which relies heavily on a scanned item number (non repeating and NOT a primary key) which needs to be entered into 4 tables, to save time I was wondering if it can be entered into the main table and autopopulated into the remaining three tables? I am very new to access so...

Ahem, sorry to sound stupid but how do I bind the combo? And more importantly what do I need to bind it to? Sorry for the total lack of Access knowhow, very new :) UPDATE: All works fine now, my mistake! I didn't know I had a hidden column so my combo box was off by one. Thank you everybody...

Many thanks for pointing that out Bob, guess I'm re-doing some forms then :) I have tried to drop a combo box in the form with the same results, is there a particular way this needs to be done? Do the field names need to be identical if I'm using the code; DoCmd.OpenForm "Buyers", , , "[Buyers...

Many thanks for that but I can't get it to work and after a few different checks I've discovered it's when I use it on an autolookup field. Is there a way around this as it's opening the form but on a a single empty record with no data. It does however work perfectly fine on normal fields just...

Many thank for the offer, the database is attached. What I am trying to do is this; In form 'Items', if the buyers name is filled in, place a button next to it on the form which when clicked will open form 'Buyers' and display the full details for the selected name. This is for my...

I came across this earlier today but it didn't make much sense to me. I have no idea how to use that information, i.e. where to put it and how to use it. Sorry for my ignorance, can't be good at everything can we!

Hi i'm trying to add a button on a form next to a lookup box (customers name) which when clicked will open the customers form and show the name selected. i.e. Form A; customers name is selected from dropdown box (populated via lookup), button clicked which opens Form B and displays the record...