1 Reply by colintrent

(4 replies, posted in General)

Thank you Derek. This is going to help so much

Go to forum: General

2 Reply by colintrent

(2 replies, posted in General)

Brilliant!

Thank you

Go to forum: General

3 Reply by colintrent

(4 replies, posted in General)

Thank you smile

I'll have a look for some scripts as a starter and see if I can make it work.

Go to forum: General

4 Topic by colintrent

(4 replies, posted in General)

Hi everyone

I know this is a big ask....is there a way to create an audit trail for a database that could display in a grid or even in a report? Similar to the user grid that shows last login etc.

I am creating an HR application and I would like to be able to see which user created/updated/deleted a record. Im a beginner at SQL and dont know Pascal.

Is there a way to create this in MVD?

Go to forum: General

5 Topic by colintrent

(2 replies, posted in General)

Hi

Still learning MVD, can someone tell me if there is a way to change the default form after logging in?

Go to forum: General

6 Reply by colintrent

(7 replies, posted in General)

Wow thank you so much for this solution Sparrow.

i have been trying to figure this out. Thank you everyone for your help

Go to forum: General

7 Reply by colintrent

(7 replies, posted in General)

Thank you so much for the help and advice Derek. I think I know what you mean now.

I just deleted a lot of the tables in my original attachment to avoid confusion.

Just a question... When using fixed version, do you maybe know why when I select a company, it stores a digit  (see screenshot) and not text?

Go to forum: General

8 Reply by colintrent

(7 replies, posted in General)

Hi Derek

Thanks for your quick reply.

I have attached the file. Sorry i got my fields confused. I am trying to add a new company location and and choose a company from my "companies" table to save in my "company location table" Sorry for all the confusion.

Now Im getting a sql error.

Please could you show me where Im going wrong.

Go to forum: General

9 Topic by colintrent

(7 replies, posted in General)

Hi

Can someone please help. I am experiencing a problem with a combox not saving the values to a table.

So, I have a cost centre table and a country table. Both have "country" as a text field. The country table is marked as a dictionary. When I select a company from the combobox on the cost centre form and save the record, it does one of two things. It either:

1. Populates the country field in the cost centre table with a digit

OR

2. It just doesn't save the selected country to the country field in the cost centre table.

I have created relationships.

Go to forum: General