Can we have more than one table for card form

sridhar

Suppose if there are two tabs in a card form. I want to use one table for the "Generel" tab and the other table for another tab.

Is it possible and how we can manage that?

Marije_Brummel

You can put a subform on the other tab.

sridhar

Hi Mark Brummel,

I think we can use the sub form only to display the list form...

kine

Yes, you are not able to have two tablesboxes on one form, but you can include subform with the tablebox... of course, it depend on what is your target and why you need that...

i4tost

Give me an example why it is needed to have 1 to 1 relation (one record from one table relates to one record in another table). In other cases - list is a solution.

DenSter

There are no examples, that's just the way it is.

In that subform you can have regular controls though, you don't HAVE to use a tablebox in the subform I don't think.

STK

I had the same problem and now I took a subform with a table box in it. I made a connection to the Microsoft VSS and the left table shows me the projects and the right one the files which are stored in the VSS DB.
But now my problem is that the subform is just updated if i click into it and browsing is a little bit difficult

Does anybody know how i can update the subform (the table box on it) on the main form if a the record is changed?

Kowa

i4tost wrote:

Give me an example why it is needed to have 1 to 1 relation (one record from one table relates to one record in another table). In other cases - list is a solution.

If you spread data into two tables with a 1:1 Relationship ( may be necessary if the record size exceeds 4000 bytes) then you can get the second table field contents to show up by coding a <SecondTable.get(PrimKey)> in the OnAfterGet RecordTrigger of the form. Create Textboxes in the form using <SecondTable.FieldName> as the SourceExpression. The downside is that you will not be able to set any filter on the fields of the second table in this form.