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