Re: Lotus 123 R9 database mechanics

Sounds like you need two tables.
One would be invoice with invoice number as key field,
the other would be orders which also contains invoice number. The two tables
would be linked by invoice number.
You'd have a one to many relationship. When you printed an invoice, you'd
have orders as a repeating field.

"David Cartier" <dcartier@xxxxxxxxxxxxxxx> wrote in message
news:441D80FC.6040003@xxxxxxxxxxxxxxxxxx
I have created in the past simple flat databases as in a phone book type
environment. I am attempting to create a simple INVOICE type database
where I use an invoice template for data entry, and another identical
one to recall an entry or print. What I can not figure out is if INVOICE
# 2 has 2 jobs under description. IE washing dishes 5 Hrs & the next
line drying dishes 2 hrs. The how do you save this in order to re-call
it as all tghe other entries use 1 line and the description & hours
field have the possibility of several fields?
Thanks Davis



.

Relevant Pages

  • RE: Automate a default value
    ... First thing this morning I created a combo box on the AV invoice ... Data entry form and that was a good solution. ... Control source Recap Date ... > called RecapDate. ...
    (microsoft.public.access.forms)
  • Re: Sub form not displaying as continuous
    ... "John Vinson" wrote: ... >>and data entry = False and no difference at all. ... >>Invoice number does this ... > as the Master Link Field and Child Link Field of the Subform control ...
    (microsoft.public.access.formscoding)
  • RE: Table Design
    ... this database is created on the fly. ... in and receives an invoice preprinted by head office. ... The data entry operator enters Inv number, ... > form enter the transaction data or have a sub form tied to the transaction ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sub form not displaying as continuous
    ... >and data entry = False and no difference at all. ... >looked at the tables and noticed that the Ordersub was not keyed on ... >Invoice number does this ... as the Master Link Field and Child Link Field of the Subform control ...
    (microsoft.public.access.formscoding)
  • Re: Closing a report after emailing.
    ... > When I have completed the data entry using an Input form I press a button ... > This opens the invoice in report format ready for emailing. ...
    (microsoft.public.access.modulesdaovba)