What exactly is the logic by which Bill #7 relates to Lahore and DC / Gate Pass #: 11204?


How does GPNo 3504 fit into this calculation?
Does Bill # equate to BillNO or BillId?
What does DC / Gate Pass # represent?

I suggest you tell us more about the application to help put the terminology into some business processes.

Can you tell us in simple, plain English what this business is lead us through the major processes in general terms?

Every table should have a primary Key. Field and object names should not have embedded spaces nor non alphanumeric characters.

My concern is that you may have many hidden entities within your existing tables. But to me there is insufficient info to offer more focused advice.
Good luck with your project.