Hey guys, I have to say upfront that my knowledge of Base is very limited. I'm trying to build a database which can be used to invoice customers for a travel agency. Most importantly is flights. I have the following tables set up:
Customer
Passengers (which are not always the customer)
Airports
Invoices
Obviously the passengers need to be associated with the customers...but I have no Idea how to associate it with the customers.
The airport table I got from an open source list of IATA airports. The idea is when I invoice a flight, I can search via IATA code or airport and list it for reference on the invoice
So here's how I envision it on the invoice form:
1) search customer database and all relevant datapoints appear (Last name, first name, address etc)
2)The selection of possible passengers can be selected, but only from the passengers associated with the customer
3)Date of departure and time free text entered
4) Search departure and arrival airports and display
5) Enter net price
6) Commission is automatically calculated
7) Total price appears at the bottom
8) Invoice can then be exported to PDF, I assume via a report.
Am I making this more complex than it needs to be? I fortunately have a lot of time to complete this project, but I need to do it. Any feedback would be great...If you'd like me to upload my project I will. I would be grateful for any help anyone could provide.