I am a total Nerd, a rank beginner, so apologies for that to start with.
I am working on an Access app for a real estate project and have thought of laying out the tables in sequence as events would normally happen.
After the designs have been drawn up and approved we would have Inventory (table 01Units) to begin with.
As the project develops, intending purchasers would make enquiries (table 02Enquiries) and their details would be stored in table 03Prospects
Once they finalize a purchase that data would go in table 04Bookings. At this point the prospect has become a customer. Should a table be introduced here.
Once a booking is made, Bills will be raised as per work progress (table 05Billing)
As Bills are raised, payments will be made (probably in parts) and go into table 06Payments
Once payments are received, receipts will be issued and data entered into 07Receipts
Prospects/Customers are usually brought in by Brokers, whose data will be entered into another table 08Brokers. Thill table will have 2 FKs which relate it to 02Enquiries and/or 03Prospects or 04Bookings
A schematic pdf is attached to make things clear. Am I on the right track, or some changes are suggested. All comments are welcome.dB Design.pdf