Create a Receipt Form

A

Accessjulsanalan

I want to create a receipt form that will contain 2 tables. One table has
609 records and the other table has no records. How do I combine the two
tables to enter data and use a receipt number for each record that will
contain 5 digits. I will be very grateful for anyone who can help me with
this.

Thank you
 
D

Damian S

You haven't provided enough information... perhaps a sample of the data in
the two tables, and how you want them to interact... maybe a sample of the 5
digit receipt number etc?

Damian.
 
A

Accessjulsanalan

thank you for responding.

The first table has 609 records in it. The second table has none. I want
to merge the first record with the second record. I tried adding the fields
into my first table but I get a message that says too many fields. I counted
the fields and I only have 100+ Here is a sample of what I am trying to do.
CASE# Address
receipt#100000 (need this field to autonumber other than "1")
7.1198 SMOKE RANCH
34458 INTERNATIONAL PARK

zoning fees public works and engineering

change of zone fees Public works and engineering fees

running totals would be in this table that would calculate as a person pays
for a particular service.

I hope this wil help you help me. I really appreciate your help.
 
Top