Database Review

[pupkiss1965]

Ken

I was wondering if I could send you what I have for review. I am not
getting the results that I should be with the subforms. It is showing 3
records for Director and 3462 for Officers and 3600 for shareholders...I am
pretty sure that one company doesn't have that many shareholders. LOL. You
would really help me out if you could review this and advise me of things
that I have done wrong. Once I can figure out what I am doing wrong then I
will be adding fields such as the addresses for the members and adding at
least 3 searches (search by member name, company or sdc file number).

 

[Jeff Boyce]

Ken

We aren't there. We can't see how you are doing whatever it is that you are
doing.

It sounds like this could be a query. Please post the SQL statement of the
query you are using.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Ken Sheridan]

Did you join the tables in a query as I suggested and open that to see if the
right officers, directors and shareholders were being returned per company?
If so and the query's results look OK then the most likely source of the
problem is that the subform and form isn't linked correctly. The
LinkMasterFields and LinkChildFields
properties of each of the three subform controls should be CompanyName.
These are properties of the subform controls. A subform control is the
control in the main form which houses a subform.

I don't normally look at files on an individual basis, but as we've come so
far with this and I suspect the problem will probably be not too difficult to
identify I'll be happy to take a quick look at it. Mail it to me at the
following (munged) address. If you are using a later version than Access
2002 be sure to convert the copy you send to 2002, as I'm still in the dark
ages. My email address is:

kenwsheridan<at>yahoo<dot>co<dot>uk

Ken Sheridan
Stafford, England