Hi There,
OK, I believe there probably wont be a way to do this. I have a database with a table and two of the columns have only a set amount of data. one row has 4 consistant values (for Brevity, I'll just make them fruit - Oranges, Apples, Pears and Berries) the other column, again, has a consistant amont of values (SuperMart, JollyGrocers, FruitMans)
There is another column that holds costs so the table would look like this in the db
Fruit-----------Market---------Cost
Apples--------SuperMart---------$1
Bananas-----SuperMart---------$2
Oranges------SuperMart---------$3
Pears----------SuperMart---------$1
Apples--------JollyGrocers------$3
Bananas-----JollyGrocers------$2
Oranges-----JollyGrocers------$2
I want to produce a repeating table in Infopath forms that will use the database table as the data connection. However, I want to know if there's a way where I can display the repeating table like so:
Fruit------SuperMart-----JollyGrocers-----FruitMans
Apples--------$1----------------$2-----------------$3
Banans-------$2----------------$3-----------------$3
Oranges------$3----------------$1-----------------$7
Pears----------$1----------------$3-----------------£2
This would also have to be a submitting table, meaning I'd have to be able to add info to the table. Slightly strange question, however, this is incase there are more supermarkets or fruit added to the table. If I new there wouldn't be any more Markets, I'd make them columns. (of course, I'm only using markets and fruite as an example)
Hope that makes sense.
Thanks for any help that I recieve.