Tabular form

[dazoloko via AccessMonster.com]

Dear All

Im hoping someone can help me.

I have a table containing personal information relating to service users.
Within this table is a Key Field DP number.

I also have a table which contains Financial transactions of service users.
The fields are Transaction Date, Transaction Type, Transaction Amount

What I want to be able to do is to enter multiple transactions relating to a
particular service user.

I thought the way around this would be to create a tablular form where I can
just tab through to the next transaction on completion of the previous one.
Where though, would I enter the DP Number ?

Hope this makes sense.

Cheers

D

I only want to enter the DP Number value once though

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200902/1

[dazoloko via AccessMonster.com]

[dazoloko via AccessMonster.com]

Dear All

Im hoping someone can help me.

I have a table containing personal information relating to service users.
Within this table is a Key Field DP number.

I also have a table which contains Financial transactions of service users.
The fields are Transaction Date, Transaction Type, Transaction Amount

What I want to be able to do is to enter multiple transactions relating to a
particular service user.

I thought the way around this would be to create a tablular form where I can
just tab through to the next transaction on completion of the previous one.
Where though, would I enter the DP Number ?

Hope this makes sense.

Cheers

D

I only want to enter the DP Number value once though

--
Message posted via http://www.accessmonster.com

[ntc]

Your Financial table needs to have a field for the parent Key Field DP
number as a cross reference.

If you set up your form and insert a subform (which is sourced on the
Financial Table) the wizard will link the cross reference fields as you
insert that subform; and the cross reference value will auto insert into the
Financial Table whenever you generate data in this subform.

[Dale Fye]

Rather than using a Tab control, use a subform.

Create a form based on your Transactions table (there should also be a DP
field in that table). then add a subform to the main form, set the
SourceObject to the name of the transactions form, then set the Link
master/child fields to your [DP] field.

Now, when you select a record in the main form, the subform will display
those transactions that pertain to that DP. And when you add a record to the
subform, the [DP] field will automatically get filled in with the [DP] value
in the main form.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

[dazoloko via AccessMonster.com]

Thank you kindly for your response, nuch appreciated.

D

dazoloko wrote:
>Dear All
>
>Im hoping someone can help me.
>
>I have a table containing personal information relating to service users.
>Within this table is a Key Field DP number.
>
>I also have a table which contains Financial transactions of service users.
>The fields are Transaction Date, Transaction Type, Transaction Amount
>
>What I want to be able to do is to enter multiple transactions relating to a
>particular service user.
>
>I thought the way around this would be to create a tablular form where I can
>just tab through to the next transaction on completion of the previous one.
>Where though, would I enter the DP Number ?
>
>Hope this makes sense.
>
>Cheers
>
>D
>
>I only want to enter the DP Number value once though

--
Message posted via http://www.accessmonster.com

[dazoloko via AccessMonster.com]

Thank you for your response, much appreciated.

D

ntc wrote:
>Your Financial table needs to have a field for the parent Key Field DP
>number as a cross reference.
>
>If you set up your form and insert a subform (which is sourced on the
>Financial Table) the wizard will link the cross reference fields as you
>insert that subform; and the cross reference value will auto insert into the
>Financial Table whenever you generate data in this subform.
>

>> Dear All
>>
>[quoted text clipped - 20 lines]