R
Ringwraiths
Hi all
A complete newbie here
I?m making a database for an estate agent, would the following fields
in the tables be appropriate??? All the tables will be ?linked?
together.
What changes/additions can be made???
Tbladvert
advertID*
PropertyID
NewspaperName
Tblappointment
appointmentID*
buyerID
propertyID
time
details
tblbuyer
BuyerID*
PropertyID
SolicitorID
Date
Buyerfirstname
Buyerlastname
Buyeraddress
Buyerphone
Tblproperty
propertyID*
BuyerID
vendorID
AdvertisementID
Date
PropertyType
Bedrooms
Bathrooms
..
..
..
..etc?.
tblvendor
vendorID*
PropertyID
SolicitorID
Date
vendorBuyerfirstname
vendorBuyerlastname
vendorBuyeraddress
vendorBuyerphone
tblsolicitor
solicitorID*
vendorID
buyerID
please reply to me on (e-mail address removed)
thank you all for any input
A complete newbie here
I?m making a database for an estate agent, would the following fields
in the tables be appropriate??? All the tables will be ?linked?
together.
What changes/additions can be made???
Tbladvert
advertID*
PropertyID
NewspaperName
Tblappointment
appointmentID*
buyerID
propertyID
time
details
tblbuyer
BuyerID*
PropertyID
SolicitorID
Date
Buyerfirstname
Buyerlastname
Buyeraddress
Buyerphone
Tblproperty
propertyID*
BuyerID
vendorID
AdvertisementID
Date
PropertyType
Bedrooms
Bathrooms
..
..
..
..etc?.
tblvendor
vendorID*
PropertyID
SolicitorID
Date
vendorBuyerfirstname
vendorBuyerlastname
vendorBuyeraddress
vendorBuyerphone
tblsolicitor
solicitorID*
vendorID
buyerID
please reply to me on (e-mail address removed)
thank you all for any input