automatically create record in related table

[ukmgranger]

Hi there,

Hopefully this will be an easy one for you 'Gurus'.

I have a two tables that have a related ID no. Table1 has a portal to enter data into Table2.

The problem is that a new record will only be created in Table2 if I enter something into the portal.

What I want is whenever a record is created in Table1, a record is also created in Table2 (with the same ID).

Hope this makes some kind of sense!

Regards

Martin

Edited March 9, 2006 by Guest

[IdealData]

If you want "automatic" then you'll need to script it. you can script tyhe sequence of data entry that would ordinarily be made "by hand" in a portal.

Why do you want a new entry in table2 when you create in table1?

[ukmgranger]

I'm not sure that I can adequately explain, but I'll give it a go.

Table1 contains invoice information (name, date etc.). Table2 contains stock sold relating to that invoice. Table3 (not mentioned before) contains expenses relating to that invoice (petrol, parking etc.). All are related by a common 'auto-enter serial' ID.

I am trying to create a 'by month' report with info from all 3 tables. The problem I am running into is the report doesn't show a record if there is no data in one of the tables.

I thought that the easiest solution would be this:

when I create a new Invoice, a record is automatically created in Table2 & 3 so that each table has exactly the same number of records with the same ID.

I'm sure that I should probably be looking at the report for the answer, but I'm pretty new to this and many things are truly beyond me.

All help is greatly appreciated though

Thanks

Mart