combining two inventory templates

[jjosh12]

I am trying to come up with a solution that will-

1.add and remove inventory via shipping and recieving

2.list the inventory all together so it can be viewed by sales before making a promise to a customer

3.allow the creation of an item (product catalog ID) without it having ever been entered into inventory before ust by typing it like any other inventory item.

I am trying to combine the "Inventory.FP5" template that came with Filemaker Developer to store the information for viewing and the "Sample Inventory Attachment" uploaded to the forum

#49882 - 11/08/02 08:34 AM to perform the calculations.

I have no doubt this can be done, I just dont know how or where to begin or end

I do know how to create relationships and portals, and I havn't develed into scripts much (I am an advanced newbie) but am not afraid to use scripts. What I don't know is what should be the parent file, what type of relationship to make, if I should use a portal, I understand the using of line items but I dont know how to set them up or use them.

Pretty much, what I am getting at is:

Can someone (or many people) tell me how to do this, I don't kneed my hand held, although I don't mind, but I do need detailed instructions like if I need to make a constant relationship, or if I want to check the "allow creation of records", etc. To sum it up, Im hoping that someone can provide me with detailed instructions and they dont have to worry that I will be more confused after their instructions and become dependant on their help to perform general tasks. Any input would be greatly appreciated and handsomely rewarded with much praise.

Oh Filemaker Gods I pray to thee!

In advance:

Thank you,

Josh

49882-Inv_Sample.ZIP

[zincb]

1. Change the following fields to globals:

Quantity (number)

WhereTo (text)

Cost Per (number)

2. Change the Value List, Items, to

Inv.zip

[jjosh12]

I folled these directions to the best of my knowledge and It does seem to be doing something in the right direction. Unforutnately I dont know enough about Filemaker 6.0 to figure out what is missing or incorrect. I have attached what I have at this point.

Copy of 49882-Inv_Sample.zip

[jjosh12]

zincb,

Thank you for your input. I just noticed that you attached the solution working fully. Thank you so much for your help. I am trying to learn what you did because I didnt get the same results. Maybe Im more of a newbie than I thought.

Another question.

maybe this belongs in a new post or somewhere else, but:

how would I make the fields that I want to view for the sales page:

INSTEAD OF ITEM, COUNT, and VALUE

the fields instead be...

Product Description (example (1131-80))

R-0000# (R-8541)

LOT# (HHG02)

Units Of Measure (100ML)

Quantity On-Hand (30)

Approved By (persons initials)

Location (Check Box of 6 options)

Notes (text)

If you describe how to do this one time using the field name "generic" as an example I think I can figure out how to do it for each one of these fields.

thank you again.

Josh

[jjosh12]

I am very desperate! Any clues would be very much appreciated. I am stuck.

Thank you anyone!

[jjosh12]

I have attached my current status of my venture. I feel I am close but still to far to make an educated guess what I am missing or doing wrong. I am at this point truing to get field "Lot#" to show in the summary of all inventory and act the same as the other fields like it (item, quantity, etc.)

testrun add fields.zip

[Ugo DI LUCA]

Corrupted files Josh...

[jjosh12]

Let me try that again. This should work fine. I tested it first this time.

Sorry Ugo.

Thanks

Josh

85858-Inv.zip

[zincb]

DOWNLOAD #1:

Attached is a possible solution that allows you to keep track of Lot Numbers in the same file. You may have to "hide" your other files, because Filemaker has a habit of sometimes grabbing files with the same name as the ones you used in your relationships.

There! That was confusing! What I am trying to say is that the attached zip file contains two files named, "Records In" and "Records Out", the same as the ones you are curently working with on your hard drive. When you open the Input file that is in the attached zip file, Filemaker *might* link it to the "Records In" and "Records Out" files on your hard drive, and not the ones in the zip file.

lots.zip

[zincb]

DOWNLOAD #2:

To finish, here is a possible solution without the ability to track Lot Numbers. Between the two of them you will get a general idea of one way to skin this armadillo. In the scripts, you will find a lot of workarounds to keep track of the Lot Number. Ideally, multiply-occurring data should get its own file, but then you trade these workarounds for more files and relationships. For conceptual simplicity, I try to stay within two relationship-layers from the main user interface.

item.zip