You place a buton on the form to create the new record threw a script set. then get the user'name with a get(username) function.
This should be translated to the user id that is in your user table. And you associate that new expense to his id.
Need more details, ?
thanks for replying and sorry to be back so late and..I think I did not follow your explanation ..
Sorry about that but could I ask you to give me more details, indeed.
How far do you want to go in this project ?
For a simple explanation , you need to have the user table lead the expense table
Your user’s primary key will be the table link the expense log table , with the help of the date table , it will be possible to sort your reports by month
As you can see , I’ve started a basic layout of the tables needed.
The important thing is , your user table will be the creation link into the Expense log table
The user , will be creating logs associated with his ID…
The only relation that has a record creation value set is the “User Ø Expense Log”
Your users logon name should be set into the software of each user , so the system will respond automatically to it ..
From this point on , you need to fill in te basic information
Fill in the users table
The months have been added to theh date date table
Add the expense type either it be traveling in KM or miles (the conversion factor )
And the final data will be added for each user in this interface …
As soon as you type something into the description and other green items ,
the item is added to the expense log , with the users ID ,the date, Time ,
You chouse the expense type , and assigne a value to this expense..
Have a look at the startup script…
Here you go ,,it’s my demo ,,,
Fool around it..
if you do something extrodinary to this demo , , send me back a copy J
Need any more information ,,,
Glad to help
HI Earl, wow.
That was very neat, thanks a lot it seems it works perfectly.
I will start to studying it and have a look in detail how did you do it.
The only thing that I can already tell you now is that only one user (me) will be accessing the report.
IN the working scenario someone will send me an email, I place the order and upload the expenses report specifying the user , so I can keep track of who spent what. So I guess it would work like it is without other changes.
I will also start to change it a bit for my needs and I will send you , the demo modified if would like.
I hope I do not have to disturb you anymore and I think I will be able to figure out all from now on..