Hello friends I have been looking to create a database for which I would require to know some of the facts that are required to make a relationships with various fields of the tables that I have created. Also, I would want to know whether should I keep the data type of the ID field as Number or should I keep it as text. I have developed 3 tables at a initial stage and can assure you that this is just the beginning and with many more to come. These are my table lists
1 Clients table
- ClientID, Client Name, Add1, Add2, City, Postcode
2 Jobs Table
- JobID, ClientID, Works Description, Date Received
3 Invoices Table
- InvoiceID, ClientID, JobID, Subtotal, Vat, Total
So how should I carry out the joins that are eventually needed in a relationship with all the fields of the table.
Bookmarks