I have two tables within my application. 1: Is the holiday booking thats been booked and the other is the holiday booked from their time sheet. They both have the same user names witin the tables. I would like to compare the two tables to make sure that the time entered on the timesheet is the same days booked on the holiday request. I’ve tried joining but cant seem to automate the join to the user name ect.. cant seem to get the two tables within a Pivot view. Wonder if anyone could assist with some suggestions.. Its getthing the two tables linked which is the problem… Thanks
If you’re talking about existing data, you will need import one of the tables again connecting tot he other on the import. Otherwise you would have to do it manually one record at at time which is okay of you only have a couple dozen records. You might even want 3 tables - users connected to the other two, but I don’t know your setup so maybe that doesn’t make sense?
Thanks for the information, I did try this on the import but, It wouldn’t pickup the parent link for some reason… Even when I know the field is like for like..
Vin
Can you post up how the connection is defined between the two tables? That might help us give you some advice …