Subform?? 1

[Dlynn]

I am trying to construct a help desk call type database that has customer info & then I will need to have some fields for calls that the customer makes.

I have setup a regular database with a subform.

How come the info from the subform doesn't show up when I open the customers info in a form, the subform is empty.

Is there naother way to achieve a database as such??

Thanks for your help..

Dlynn

 

[Smack]

Is there a relationship between the tables? A form, or table have to be linked in some manner in order for it to know there is an association. An example of a form I have is tableA with an ID NO which is an autonumber primary key. The subtable, tableB has id no set as long integer. I create a one to many relation from this. Then create a form from tableA and create another form from tableB. I then insert a subform into formA, using formB as the source, when linkink the fields, I select ID No.
Hope this helped.
-Smack
"Low Tech"

 

[SimonDavis]

Well, the good news is that it's definitely possible.

The bad - a pile of questions!

How have you constructed this - you have made a form to use as the subform, right? Does this display what you want to see when you open it by itself? (except for the fact it might not be filtered - that's not important now)

How have you defined this on the main form - as a subform? And now it is important to look at how the subform is filtered. You are picking up the customer criteria from the main form? How are you doing this.

More details please!

 

[Dlynn]

SimonDavis,

I am trying to do a help desk database. In which when you search for a customers name, all the calls that that one customer has made will appear on the same page. So I setup a subform. I don't know if there is an easier way to accomplish the same goals, if so I am more then willing to try something else. So in order to see the contents of the subform, I have to get out of the original database & then open the subform to view anything that was entered.

Any Suggestions Will be Helpful.

Thank You

 

[AArt]

I've done a number of these. Your main form should be based on a recordset of all your customers. If you have one table with just a list of customers, use that. Or use a "find duplicates" query on the table that contains all the calls.
The Subform will be a continuous form. Sometime the Subform wizard will just help you link it. If it doesn't, just make the record source for the subform a query. where you select the Customer ID, put the following in the Criteria:
[forms]![mainForm]![Customer ID]
Voila!