Importing multiple to one record....

[Mike-LI-NY]

Ok.. so here's the situation

I have one databsae of products from which I want to generate my orders. The fields include company, category, sku, price, total, etc etc

So I can sort for example, for everything I want from Company A, or I can sort for everything I need for a certain department.... makes sense?

Now what I want to do is find all my Company A's that I want to order from and export that data to my purchase order database. But here's the catch - when I import them into the POs, it creates a new record for each product, but what I want it to do is place all the products in a list on the PO page, rather than create a new PO for each individual product... Any ideas??

Thanks!

Mike

[email protected]

MSN: [email protected]

AIM: CanadaMike20

ICQ: 38736924

[cjaeger]

do not import into PO, but PO line items.

Check your solutions structure (are you using repeated fields?)

[Mike-LI-NY]

I work for a summer camp and there are many parts to a camp - ie candlemaking, fine arts, drama, horseback riding, etc. Each of these departments gives me a list of what to order from the database of products. So I have a product file in filemaker and on each product sheet, I put in how much each wants. It's very possible that someone in candelmaking and fine arts will want the same product, or will want porudcts from the same company as we order from 12 different companies. So all their order informaiton is in. I now do a find for all Company A products with an order quantity greater than zero. This represents all of my Company A order.

Now I would like to save that as a purchase order - so I've set up another file - my Purchase Order File. What I would like to do is somehow import all the orders for COmpany A to that file - like all on one purchase order, but instead of all the products going into the portal on the PO, it's creating a new purchase order for each product - PROBLEM 1. I need to figure out how to make many records go to one.

PROBLEM 2 - I need to reset the "order" quantity in the Product file to Zero - which isn't a problem when I do the export, I can do a replace, but if I were to do some sort of lookup or relationship with the PO file, then that owuldn't work.

So I'm asking for help with problem # 1 I guess, and then I can go from there - or maybe you think I'm doing this entirely wrong, in which case I'd also enjoy a repsonse

Thanks so much everyone!

Mike

MSN: [email protected]

AIM: CanadaMike20

ICQ: 38736924

[dbruggmann]

You have to go with Christians advice.

You need to set up at least four files:

Companies.fp5, Products.fp5, PurchaseOrders.fp5 and LineItems.fp5

For each list you get, you create then a record in PurchaseOrders.fp5: There you need a portal from Products.fp5 to choose all the things this camp part wants. For every product you choose here, you create a new record in the LineItems file (storing the OrderID, ProductID, CompanyID and CampPartID). Now you can set up a portal in Companies.fp5, which shows all the ordered products for each company.

That's a simple explanation. Search FMForums for