m Jimmy, nice to meet everybody. Ive been trying to develop an app to help my business, but i ran into some problems. I will try to describe it as best as i can and i would really appreciate some input from someone more knowledgeable.
My tables are the following :
Customers(CustomerID ;First Name ;… ;CustomerAddress1)
Products(ProductID ;Brand ;… ;Qty)
Orders(OrderID ;Date ;CustomerID ;ProductID ;DeliveryID ;Status)
OrderDetails(OrderDetailsID ;OrderID ;ProductID ;QtyOut ;PricePerUnit)
Deliveries(DeliveryID ;DeliveryAddress ;DeliveryCost; DeliveryDate; DeliveryStatus)
I am trying to create a map view of deliveries. The problem at first was that deliveries didnt have any address columns on which i could base my map view on. I added a virtual column GetCustomerID with the following formula, to retrieve customer id based on delivery id from Orders table : LOOKUP([_THISROW].[Delivery id], Orders, Delivery id, Customer id)
I then added a DeliveryAddress column with the initial value being set to retrieve CustomerAddress1 from Customers table based on value from GetCustomerID column.
LOOKUP([_THISROW].[GetCustomerID], Customers, Customer id, CustomerAddress1)
The problem is that the formula does not work for CustomerAddress1 giving the following error :
Unable to find column 'Customer Address 1’
But it works fine with any other column as input : FirstName, LastName etc.
This has been driving me crazy for the past 2 days. If anybody could help me get out of this hole.
Why isnt the formula working for the address column but works for any other type of column ?
Maybe im going about it the wrong way and should not have another table just for deliveries ?
Thanks for taking the time to read through all my non-sense.