Still need help

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

Guest

I am searching for 3 days and every post that could help me, but my form
still not working. I am open a form (from table) through a command button
OPEN FORM, with specified data, cycle to current record, and, etc... NOthing
seems to carry that last data to the other form to a subform. I am confused,
desperate. Any sugestions??
 
I try to do like the example in ORDERENTRY order by customers, my 3 forms
came for 3 tables, and proto id, week id, ad id is the link between them. The
first form PROTO opens a second one with a subform,it is working well. But
the last form was suppost to carry the controlname of the mainform current
open, and carry the ad weekly details for that specifically week/proto. Tia
 
I hear you say that you can't get your subform to work.

I suggest you look at an inventory example or Northwind example.

I have had luck setting up two tables using referential integrity. One table
is the list of customers, employees, etc. The second table is a list of
transactions based on dates, invoices, cases, etc.

The subform work great, but in order to set them up right you should use a
primary key on the Customer type table and allow many on the invoice table,
where you have a one to many relationship set up. You will need to study
cascading updates and pay a lot of attention to the potential errors created
by incomplete input.

Just a helpful hint.
 
Txs, I think I am re-building, it is very simple, but I could'nt make work.
I am selftaughter also, and I think cascade will the next step. But I don't
know if I go this far. Thanks anyway.
 
Back
Top