N
Nik
I creating a form whcih will prompt users to get certain data from our
clients, depending on certain factors (e.g. What Accounts Package do they
use, Who do they trade with and how do they communicate.
I have created three simple queryes (ID, Link Type and Name) which I have
merged into one Union query.
I have a table to store the link between paragraph and accounts system /
Trading Partner etc. I have a LinkType field with 3 possible values (B, M,
T). I have a field called LinkID which will store the relevant ID. I want to
use alookup to display the possible entries, but filtered based on what the
Link TYpe is.
i.e. If the user wants to link Paragraph 1 to an Account System, then only
accounts systems should be shown in the Lookup list.
This is at the early stages of testing (feasibility etc), so at this point,
I do npot want to create a form to do this (this will be done if and when
the Testing is successful)
Can anyone help?
clients, depending on certain factors (e.g. What Accounts Package do they
use, Who do they trade with and how do they communicate.
I have created three simple queryes (ID, Link Type and Name) which I have
merged into one Union query.
I have a table to store the link between paragraph and accounts system /
Trading Partner etc. I have a LinkType field with 3 possible values (B, M,
T). I have a field called LinkID which will store the relevant ID. I want to
use alookup to display the possible entries, but filtered based on what the
Link TYpe is.
i.e. If the user wants to link Paragraph 1 to an Account System, then only
accounts systems should be shown in the Lookup list.
This is at the early stages of testing (feasibility etc), so at this point,
I do npot want to create a form to do this (this will be done if and when
the Testing is successful)
Can anyone help?