Thanks I have done lots of reading on normalization I have 3 access books here with me and understand it to a certain degree but I do not have the experience of building multiple tables to know if I will have problems and to put it simply someone who does this for a living or even does it as a...
so let me get this straight as I have now designed my 5 tables I may have one more to add maybe (will get a screen shot on here soon) , In the employee table I have my primary key as employee ID this is then linked to a foreign key in rental properties named employee ref and also linked to a...
Thanks again, thats brilliant I didnt realise that the primary could link to many foreign keys but I suppose thats what 'one to many' in relationships means. Im seperating the properties tables now and gonna stick them up on the actual database and see if theres any problems.....Luckily i do not...
Hi me again I now have thought of 4 tables they are as follows though I need to have 5 minimum or even 6 and I am having difficulty thinking of a way of linking the final tables.....I have all the other info for populating tables its just the relationships that are stressing me out. Ive just...
Thanks for your help sorry for dely in responding couldnt log in all day today .......
First name and seconda name just meant say Bruce.....WIllis thats all !
C Brighton thats a great idea as I was wondering how I could link the table to other tables and your use of the primary and foreign...
Hi all
Im new to all this so please be gentle....Im currently doing a degree in Business and for IT we are doing access2007, for our 100% Continuous assessment we have been asked 2 come up with a simple database for a business . I have been given a estate agent / property management business...