Linking pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a two-page form. In the first page we input client data and in
the second page we want to input a table to keep track of the payments done
by each client.
 
When you record payments, you need to know what the paymens are for and
whether the payment is payment in full for something or whether there are
multuple payments for the same thing. Payment in full for something is like
a payment for gasoline when you fill up your tank. Multuple payments for
the same thing is like monthly mortgage payments over fifteen years.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
you don't say what your *tables* structure is; you should have, at minimum,
two tables, as

tblClients
ClientID (primary key)
<other fields that describe a client, but NOTHING about payments>

tblPayments
PaymentID (primary key)
ClientID (foreign key from tblClients)
PaymentDate
<other fields that describe a single payment from a single client, but
NOTHING about the client other than the ClientID>

that's a standard one-to-many relationship: one client may make many
payments, but each payment is made by only one client.

a standard form setup would be a main form bound to tblClients, with a
subform bound to tblPayments; the mainform/subform linked on the ClientID
field in each table.

hth
 
Steve said:
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
Click to expand...

Is that true ???

Hey Steve !!
Well... We did know that you are NOT an Access resource at all !!
But .... A REAL resource you are with Excel .... Ha ha ha. !!
Asking questions about looping a spreadsheet, asking about Excel-events, not knowing how to add buttons and code ???
http://groups.google.nl/group/microsoft.public.excel.programming/msg/d7d79687dec86195?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/a4a8b9b40fe5c313?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/46a46c0dc6dc9c15?hl=nl

Curious about your Word skills... You DO know that you can bold text and such ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3950+ pageloads, 2500+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 
Back
Top