ok, file is being uploaded. some minutes to wait . . Nick
5 mins to go,
Ok done it is at:
What I need is a new table, or an export spreadsheet, that contains some fields from table: Consumables Vertical (fields are: Manufacturer, Machine_type, Machine_name) and contains the data held in table: protocopy-bluepark-products (field: SKU)
But I must only have 1 row for each value from Consumables Vertical.
on that row should be all the matches from the protocopy-bluepark-products (field: SKU)
I have loaded an example, spreadsheet at:
The linking field name(s) are
Consumables Vertical: Consumables = Protocopy-bluepark-products: Spicers_Code
You may see the relationship link I created?
Are you clear on my request?
Oh & I have a deadline . . . which is why I asked for help. a couple of hours is ok, but it would be re-assuring to know if you think you can fix?
OK, that is a step closer, but the layout is not what's required:
I've added from table: Consumables_Vertical, the fields for "Manufacturer" & "machine_type" to produce this example on 4 rows:
But what I need is the values listed for "SKU" all on one row, like he sample loaded at http://wikisend.com/download/488766/product-finder-sample.csv
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
I would like it to be cancelled thanks