On Friday 18 January 2008 01:16:01 James Elliott - WA Rural Computers wrote:
> My bookkeeping currently a workbook made up of several spreadsheets in OOo
> Calc ver 2.3 running under Windows XP, and it is working well.
>
> I am currently setting up a database in OOo-Base (ver 2.3) with a view to
> migrating my data to it, to hopefully use from the end of the financial
> year, onwards, but my database skills are a bit rusty and I would
> appreciate some advice.
>
> In my tblCUSTOMERS I have the following fields:
> CustID (auto-integer, Primary Key)
> FirstName
> MiddleInitial
> LastName
> Address1
> Address2
> ... etc.
>
> In my tblJOBS I have the following fields:
> JobID (auto-integer, Primary Key)
> CustID (Foreign Key to CustID in tblCustomers)
> DateOfService
> Requirements (computer repairs or upgrade required)
> Tasks (work carried out - itemised)
> Time (Billable hours spent on the job)
> ... etc.
>
> So far, so good. I have two tables containing different data from each
> other, apart from he Primary/Foreign Key relationship which allows me to
> pick up customer data to add to a job report.
>
> But! ... the next table I started to build was tblInvoices (invoices to
> customers). I am creating a tblInvoices because I have an Invoice Sheet in
> my spreadsheet version of my bookkeeping. The fields in the database
> version of tblInvoices would be:
> InvoiceID (auto-integer, Primary Key)
> InvoiceDate (date invoice prepared)
> Date1 (Foreign Key from tblJobs)
> Date2 (Foreign Key from tblJobs)
> CustID (Foreign Key from tblCustomers)
> ... etc
>
> In fact, all of tblInvoices, apart from InvoiceId and InvoiceDate would be
> Foreign Keys referring to other tables.
>
> My question is - Do I need to put all these foreign keys in my tblInvoice,
> or should I just record the new information like Invoice Number & Date, and
> just one Foreign Key to each of the tables I wish to get information from.
> Should an Invoice be a report rather than a table in its own right?
>
> These are my current spreadsheets:
> Invoices from Suppliers
> Invoices to Customers
> Job Notes
> Bank data (Exported from Internet Banking)
> Purchase Orders
> Quotes
> Service Reports
>
>
> How many of these would you make into tables?
> How many Foreign Keys should one have in a table?
>
> Many thanks, James
What specifically do you want to accomplish in your Invoice table? What
information is going to be contained in it? If I knew that I could give you
better advice.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
