user defined value list (plus standard)

[kiwiora]

Hi,

I have an invoicing db i'm trying to write. What I would like to do is generate a list of fee types which includes approx 10 standard choices, plus whatever else the user has added to their personal list.

So far I have (in short)

Table 1 - FeeList; fields:

{Type} (radio choose GST or NONGST)

{login} (text)

{Name} (text - name of fee)

{join} (type & login)

Table 2 - Invoice; fields:

{glogin} calc field (get(accountname))

{GSTJOIN} calc field ("GST" & {glogin})

{NONGSTJOIN} calc field ("NONGST" & {glogin})

I have then set up two table occurrences between 1) GSTJOIN & join 2) NONGSTJOIN & join

I have two value lists of the field 'Name' - with show only related values (GST or NONGST)

Apart from the fact that I can't get the value lists to display (will continue to nut that out), the thing that I want to do is create 10 standard entries that will always appear on each user's list.

e.g: User 1 - Company search fees; postage & petties; [userdefined1a]; [userdefined1b]

User 2 - Company search fees; postage & petties; [userdefined2a]; [userdefined2b]

Using the current relationship it would mean having to repeat the "company search fees" & "postage & petties" for each user

I hope that makes sense

Thanks in advance

[SlimJim]

The following suggestion springs to mind but may not be secure between users (and I am no help when it comes to that anyway) but one possibility. Set up a table with User, Fee fields. In the first record put a list of all users separated by returns in the User field and a list of all common fees, again separated by returns in the Fee field. In addition each user has their own record in the table with their User Name and Fee list. The value list will then be the values from Fee related to the user.

[Ender]

I would utilize the FeeList table and add those 10 records to each user's FeeList. It's not that hard to set up a routine to create these, and it keeps the process the same for everything else.

It may be useful to add another table of Fees, and use this to hold those 10 defaults plus any fees that the users can choose from when building their customized FeeList.