Working with Different Order Services

[francogaspari]

Hi , I am working on a personal insurance agency, I just have one or two questions here:

So I have :
tblClient : Name, address……
tblAgent: Name, address…..
tblInsuranceCompanies: Name, Address….
&
Let’s say a : tblCarOrders: OrderID, TransactionDate, ClientID, AgentID, CarMark, CarModel, PlateNumber, PaymentID,
tblOrderDetails: CarOrderID, CarPolicy, PolicyCodeNumber, ActiveDate, expiryDate
tblCarPolicy: CarPolicyID, PolicyDescrpt., InsuranceCompanyID, NetPremium

& also have : tbl Payment or methodPayment …..

If I have also HEALTH and EXPAT (servant) Policies that their details structure are completly different in “Order” and ”OrderDetails” tables .
ex: tbl HealthOrder: OrderID, TransactionDate, ClientID, AgentID + DoB, ……
and tblHealthPolicy: In, Out , …… etc


And same is for Expat that is different also of Health and Cars Policy and Order…..

the question is ???? How to make all the three ORDERS ( car , health and expat) working on one OrderId to make it easly for me when I am working on PAYMENT .
Note that I am working on THREE different Order Forms here . and only Payment Table is the commun in each Form..

Thank you

[orange]

How about telling us about the application in plain English --the 30,000 foot overview?
Do you have a clear and concise paragraph that tells users/management WHAT the database is about?

[ranman256]

Best way...MAKE all three ORDERS the same...pad each with 'empty' fields that dont exist, until all 3 have the same fields. (a lot I'm guessing)