Help, im a begginer

[Guest_imported]

Hi, Im Shmail from the UK, doing a GCSE (qualification incase you dont know what that is) in ICT. I have to make a database system using MS Access and i was supposed to hand this in to my teacher 2 weeks ago, IM real stuck right now, this is what i am doing:

I am creating a database system for an estate agent. My database consists of 2 tables, one in which the details of the houses are kept, and the other table holds info about the seller. THe seller has a ID in the seller table (autonumber) and this ID number is also listed in 1 of the columns in the Property details table. What kind of relationship do i have with this??

Please help, i can't go to my teacher and ask for help as she will just skin me alive. I know this is a really basic question but please help me, im living on a knife edge right now!! thanks in advance

 

[sadromeo]

Hi,

It depends on the type of queries you need to write to pull the records from the table. If you want to know how many houses a certain seller is selling, you would link the tables by that ID number but the relationship would be one to many from the seller table to the properties table. Hope this makes sense.

Sad Romeo

 

[Guest_imported]

Hi,
Thanks for the reply,
From the qeuries i just want to pull out certain types of houses, i.e. a customer rings the estate agent asking for a 4 bedroom house in a certain area, the esatate agent has to find this house from the database - i dont know how im gonna do this bit yet but thats another thread - and give the customer on the phone full details of the house. If the customer wants to make an offer for buying the house, then the estate agent must be able to pull up his contact details on screen, which is where the second table comes in. What type of relationship would i need, and from which to table to which.

Remember im only 16, but not a dumb 16 year old. I appreciate the help so far guys. Cheers

 

[PPSAG]

I still think you want a one to many relationship. But instead of using an autonumber have you considered using a phone number or Name combination as your primary key? This would allow the agent to easily query by customer because the customer knows his phone number and the agent knows his name. And as long as you have a field for number of bedrooms and other details then those queries will be easy also. Good luck. Mooo...

 

[Guest_imported]

cheers,

The customer that is on the phone is different to the person that is stored on the database. the person on the database is the guy who wants to sell the property, and the person on the fone is who wants to make an offer for the property. once the guy on the telefone makes an offer on the house, the estate agent has to find the telephone number of the seller and tell him the good news. what kind of relationship will be required between the property table and the seller table. in the property table i have a field saying seller ID number, in the seller table the Seller ID is an autonumber unique number. PLease help.

Also.....


One of the fields in the property table states the size of the garden. I want this in metres squared. Is there anyway that the user only has to put in a figure, say 15, and the database adds m2 (metre squared) to it, an input mask/format perphaps. I really appreciate this guys.

 

[PPSAG]

The relationship between the two tables is going to depend on what you use as a primary key. The autonumber ID will work, but your agent will have to know her customer ID numbers. You could use a lookup table with addresses in it, but that might be more than you want.

On your meters squared question, when you design the form you can run a macro that will do the math for the user. Mooo...

 

[Guest_imported]

hmm, look up tables aren't too bad, i used em alot in an excell invoicing spreadsheet system i had to make. can you tell me how the look up would work and what type of relationship would i have if i did use the autnumber ID's. cheers for the help so far.

 

[PPSAG]

A lookup table would hold all of the addresses and allow the agent to find records based on a choice from that table. The lookup table would be fed by the main table that holds all new listings. Each property will have only one seller, but a property can have many offers or customers. so you have a one to one and a one to many relationship.
Good luck kiddo, I'm out of here. For additional help you might check the access home page. Mooo...

 

[Guest_imported]

cheers PPSAG, you helped out alot, and please dont call me kiddo, it makes me sound like a 10 yr old. cheers for the help, much appreciated