Send to table

[Guest]

Hi!

I have a F_MainForm, based in T_Costs, with one cboProcess to choose
processes.
In this main form, I have SubF_Data with Description and Value fields.
This subform is based in conditional quary Q_Rubrics.
In SubF_Data I have a txtProcess to "read" in cboProcess the process number.
When we write in SubF_ Data, descriptions and values, write it in T_Costs,
but the process number it doesn't go for the T_Costs.

How is possible to send the process number too that table, please?

Thanks in adavnce.
an

 

[Guest]

Hi an,

Are T_Costs and the table behind Q_Rubrics related? If they are, simply set
the Data Linking fields between the main form and subform.

Damian.

 

[Guest]

Ok,

Already I have:
IdRubric;Rubric;IdProcess;Process
in
Link Child Fields and Link Master Fields.
(?)
an

 

[Guest]

Unless you have a composite primary key on your table, you should only need
to link a single field...

Is there a field that links Rubrics to Processes?

Damian.

 

[Guest]

I haven't primary keys.
T _Processes: IdProcess(Number) and Process(Text)
T_Rubrics: IdRubric(Number), CodRubric(Text) and Rubric(Text)
T_Costs: IdProcess(Number), Process(Text), IdRubric(Number),
CodRubric(Number), Rubric(Text), Description(Text) and Value(currency) fields

an

 

[Guest]

With that table structure, there is no need for a main form/subform
relationship, as each cost can only relate to a single process and Rubric...

What are you trying to achieve?

Damian.

 

[Guest]

Sorry my delay, but without web...

In adition:
My sub form is a continuous form with pages.
Each page with a SubF_Data1, SubF_Data2, ...

I would like in theese subforms to read and write in T_Costs.
But only write in two fields: Description and Value.
Another fields, with expressions in Control Source, type:

=[Forms]![F_MainForm]![cboProcesses].Column(0)
to "read" process number, don't write in table

Thanks.
an