troubleshoot issue related to data
I have two tables Performance and PO. Performance is connected to PO using one to many relationship. The key field of performance is Date period (ex 072017) and reference field is related overhead exp...
Forum Discussion
I sounds like the table might have been 'pre-populated' with that date periods. But might not have had enough data added. i.e. The records past 2016.
Its hard to tell without seeing it, but I'd look at that table's records first. Or post back with more details that might help us understand more the issue
Its hard to tell without seeing it, but I'd look at that table's records first. Or post back with more details that might help us understand more the issue
PO tables contains purchase orders and date of the purchase. Performance table is created to track various metrics and do calculations. The data in performance table is grouped by months that is the date period which is prepopulated by month and year (ex 072017
). In PO table, I dont know how related overhead expense was/is used to relate two tables. Any idea how is it implemented?
My guess is there was a table overhead expense which might be deleted or renamed after Dec 2016 and now I am not able to figure out how can i get the data for year 2017 as the relation between two tables is broken.
). In PO table, I dont know how related overhead expense was/is used to relate two tables. Any idea how is it implemented?
My guess is there was a table overhead expense which might be deleted or renamed after Dec 2016 and now I am not able to figure out how can i get the data for year 2017 as the relation between two tables is broken.
