sub-data sheet of a sub-data sheet.

[manish]

I have a main table (say T1) where it records the amount
paid to various people. It is linked to a sub-data sheet
(say T2) which contains the details and reasons of amount
paid. Now i want to link a third sub-sub-data sheet which
should only appear if "Travelling expenses" is selected as
the Account head of a particular field only - moreover the
refrence no of its parent should come automatically. If
any other account head is selected the third sub-data
sheet should not come into play.
...is there any way around.. please i do not know any thing
about macros and VBA's.
....please help!!! anybody.

 

[Jeff Boyce]

Manish

It sounds as if you are attempting to use tables for display purposes.

Access tables store data.

Access forms display data, and offer a rich event environment that will
allow you the kind of control you describe.

I'd suggest using forms.

 

[manish]

Jeff
I am really sorry if u misunderstood my question; probably
I had it framed wrongly.
Actually I have three tables.
Table1: Amount Paid as advance
Table2 :Amount Adjusted for various A/c Heads
Table3 : Travelling expenses details
Normally table2 contains the details that make it clear
that where the advance has been adjusted. Now if there is
expenses for Travelling I need to enter more information
(like place of travel, mode of travel, fare, hotel
expenses, daily allowance etc.) Now I do not have to enter
all these if the expenses are for any other reason say -
for courier etc. So that is why I want to have table 3 as
extra information connecting to the travelling.
Please help me out as I am stuck very badly.
Please remember that I do not know any VBA coding.
Thanks at least for responding to my question.
Manish

 

[Jeff Boyce]

Manish

My first response was to your use of the term "sub-data sheet" -- in Access
this happens when you use a table. From your original description, and from
your response, it still sounds as if you are working directly in tables.
Consider using forms to display data.

As for your table structure, I'm not clear on what you are using to relate
these three tables. I'm not there, and I don't know enough about your
business to know what an A/C Head is, or how it relates.

Could you provide a brief description of the tables' data, and perhaps an
example? Here's what I'm asking for, but without knowing your specific
situation:

tblPaidAmount
PaymentID (primary key)
AdvanceAmount
AccountID (to which account was advance paid)

trelSubAccountAmount
SubAccountID (primary key)
PaymentID (which Payment is this related to)
SubAccountAmount

trelTravelSubAccountDetail
TravelSubDetailID
SubAccountID (from which SubAccount record)
TravelDetailCategory (what "fact" about travel detail)
...

I apologize if this doesn't reflect your situation -- it is my attempt to
elicit further description from you.

 

[Guest]

Dear Jeff,
I apologize for not providing the right kind of
information. Let me try again :-
I have three tables and there contents are as follows:

Advance Table Description of fields
------------ ---------------------
date date of payment
v-no Receipt voucher no.
name Name of person to whom advance is paid
Amount Amount of money paid

Adjustment table
----------------
date date of adjustment
v-no voucher no. against which adjusted
account head eg. Electricity, courier, Travelling
detail just minor details
amount amount adjusted

Now when a person is paid advance a voucher is prepared.
Later after 2 or 3 days when he spends money for official
purposes on say - Office Car fuel, Stationery, Courier
expenses, Travelling, Car Maintenance etc. he brings the
bills & invoices to get it adjusted against his advance.
this is done through the second table (Adjustment table)
Now i have made the second (Adjustment table) as the sub-
data sheet of Advance table and linked it through the
field v-no. Similarly i have made forms & its subform.
Now what i want is to have another table for details of
TRAVELLING EXPENSES.
although when a person gives the bills it will be adjusted
in the second table itself against the vr. no's and
entered under account-head as TRAVELLING EXPENSES. But for
travelling expenses we have to maintained a detailed
information such as ::

departure date
arrival date
place of travel
mode of travel - ie. by bus, car, train or air
Travel fare
Hotel Charges
Local conveyance - taxi etc.
Fooding charges
Other office expenses on tour

Now i want to arrange my form in such a way that when i
enter "TRAVELLING EXPENSES" in account head another form
or anything should popup so that i can enter the
information for that person and which will be linked to
the information in the Adjustment table
Can this be done??? and can it be linked in such a way
that the name and v-no come automatically in the TRAVEL
DETAILS table.

Sorry for such a long question. But please bare with
me..becaus i am stuck very badly and do not what to do.
Also because i do not know VBA programming.
Please advice.

Manidh