Search results

Hmm, the levels refer to different levels in the mine i work in. they are numbers and letters. ie 21c 18a 18b 32d ... should i change that to minelevel or something?

OK fixed up what you said now where do i head from here ?

My net has been playing up but i did this last night. I have to use an older format because access at work is old :( but here is what i have done. I think i have fixed my issues.

This is sooo more complex then what i thought it was gonna be... are you on for a while?

Okay here you go... there is relationship lines everywhere but i removed the lookups in tables... and fixed RI

Just fixing the fields will upload in a second :D thanks sooo much

OK sorted that, just made a 2003 mdb and imported the tables as i am only up to table stage atm.

Hmm cannot save it as and earlier version hmm will have to rebuild it i guess

I don't have that option, only able to save it as a access 2002-2003, access 2000

So you cannot view my DB? as its a different version?

OK i totally understand now, will fix that up. Also i am having a problem with relationships as I'm not sure what tho relate a field to. I am try to create a Handover between 2 different groups of people. Each handover can have multiple jobs on it. Not sure weather to relate the jobs to the...

Ok, so just at table level just have the fields related, and then at the form level put in the combo for that relationship selection.

Ok, I got confused at what you meant to i did what i did... lol. So if i use the form for the drops downs is there an easy way to update them? So making a table with answers for the form combos isn't the way to do it? Just manually input the options in each of the things i require. Jobs i am...

Thanks, well the basis of a DB is the tables that store the data so i really want to try and get them all sorted in the best way. Also i don't want this to fall over at work and be totally useless. I am struggling a bit but i think i am getting there. Its hard just using forums, chatting to...

OK I have fixed a fair bit and i think i am on track now... let me know what you think... Just ignore the forms that are in the DB as I am playing around with them to work out what things do and trying to work out how to get them nice and neat and professional looking... wish there was a...

Ok I have redone my tables and i think they are looking alot better then what i had before. I am still uncertain what to do with the Supervisor Field on the Handover Info Table and how to relate it to the employee details. Also I am wondering if I should remove the Forklift info from the jobs...

So don't make a table with the options in them? then link to that table?

Yeah i thought my DB was a bit of a mess, just going through it now to fix up lookups and relationships as it looks complicated and messy to me and i got no idea lol

Could some one please check over my tables and suggest what i can do to clean them up and relationships. I have an idea but i am lost on the path to achieve it. Gotta get the foundation totally right before i try for the forms. I am using access 2010.

Cool thanks, I understand what you mean, I have created many tables, alot of the columns in each of the tables is the same. How ever i think i have just made a mess with my tables. I want to create a form that looks like a form not a DB as my supervisor has not idea and i would just like him...