Table - Creating Fields

[landonet]

I want to capture opposition information from businesses using opposition products, some opposition businesses may use more than one of the same product, ie copier1, model1, expirydate1, rental1 - this is now for the 1st copier - what about the 2nd, 3rd, 4th copier? Must i add fields like copier2, model2, expirydate2, rental2, copier3, model3, expirydate3, rental3, copier4, model4, expirydate4, rental4, etc or is there another way of capturing the information - your help will be appreciated, thanks

 

[John Big Booty]

You should probably use two tables set up as follows

TBL_Companies
CompanyID (PK)
CompanyName
Address

TBL_CompanyItems
ItemID (PK)
CompanyID (FK)
ItemDescription

You would then populate these two tables through a form/sub form set up. The Main form would be bound to TBL_Companies, whilst the sub form would be bound to these would then be linked via CompanyID which is the primary key in TBL_Companies and the corresponding foreign key in TBL_CompanyItems.

 

[landonet]

Thanks but how will the data be stored in the database? remember that i want to capture more than one record per customer, ie one client may have 4 copiers from the same company, same model number, same expiry date, same lease - thanks

 

[John Big Booty]

You could differentiate the various copiers by their individual serial number, and there fore have a record for each machine. Alternately if you simply have a record for each rental contract and then simply record the number of copiers on the contract.

If there are various different machines on each contract you would then need to have a master record with the contract details and then a child record underneath that for each (type) of machine.

 

[landonet]

Sorry man but this is tele sales who must complete the forms and they collect info via telephone calls, from time to time the person on the otherside will not even give them all the info maybe just "supplier x" and we have "2 machines" - this then generates a lead for the other sales people

 

[landonet]

Hi, anybody who can help me with this query? I will really appreciate it as this keeps me from finishing my project, thanks

 

[Dairy Farmer]

ie one client may have 4 copiers from the same company, same model number, same expiry date, same lease - thanks

Don't make the "Product" fields unique when indexing.