mfaisal.ce
Member
- Local time
- Today, 08:56
- Joined
- Dec 21, 2020
- Messages
- 76
Dear All,
I have a Parent/child tables...
Parent Table: Sales (SNo)
Child Table : Sales_Detail (SNo)
Child Table : Sales_Payment (SNo)
Child Table : Sales_Return (SNo)
Each Parent Record has multiple Child records in each table....
Each Child Table has column SrNo column with AutoNumber format.
1. what i need is; SrNo [AutoNumber] restarts with each SNo and does not continue as new record in Child Table
2. I need to Format SrNo [AutoNumber] as SNo-SrNo
Example,
If SNo is 1, then SrNo for all child records in Sales_Detail Table should be like
1-1
1-2
1-3
1-4
and if SNo is 2, then it should be like this
2-1
2-2
2-3
2-4
Database File is attached, plz find any solution if possible...
regards,
I have a Parent/child tables...
Parent Table: Sales (SNo)
Child Table : Sales_Detail (SNo)
Child Table : Sales_Payment (SNo)
Child Table : Sales_Return (SNo)
Each Parent Record has multiple Child records in each table....
Each Child Table has column SrNo column with AutoNumber format.
1. what i need is; SrNo [AutoNumber] restarts with each SNo and does not continue as new record in Child Table
2. I need to Format SrNo [AutoNumber] as SNo-SrNo
Example,
If SNo is 1, then SrNo for all child records in Sales_Detail Table should be like
1-1
1-2
1-3
1-4
and if SNo is 2, then it should be like this
2-1
2-2
2-3
2-4
Database File is attached, plz find any solution if possible...
regards,