SPECIAL DESIGN ACCESS FORM

[ayaari]

Hi,
I want to design a form that will look like this:

customer- taken from customer table and bring all the customer- it's text
field or label.

and at the bottom all the invoice of this customer- take from a query-shown
in table.

and again next customer and at the bottom again all his invoice in table.

i have 100 cutomer so i want it to show 100 text field\label with customer
name
and 100 table with all their invoice.

if I am trying to display the main form with Continuous Forms, i am getting
a messege box that said something like this (translated) you cant use
Continuous Forms with a form that has a table or active x

how can i do a form like decribed above?
Thanks in advnaced
Alon

 

[Duane Hookom]

I'm not sure why you would want to do this. You would not be able to see all
this information at one time unless you have a huge screen and a large field
of vision. Also, you would be using network and local PC resources to load a
lot of records.

 

[Amy Blankenship]

Sounds more like what you need is a report...

-Amy

 

[ayaari]

ok, maybe i exaggeration
I have only Ten customers,
how do i do this?
thanks in advanced Alon

 

[Ofer]

Hi Alon
As I answered in the other discussion group, I don't think you can define a
sub form in a continues form, only in a single form, so you don't have much
options but to create a report that display what you want and how you want.
And create a single form, to display the records and nmove from one customer
to the other using the NavigationButtons.
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck