I am creating a new app for inventory parts ordering...I have a "Vendors" table with 5 vendors setup...Each vendor I order specific parts from...I want to create a Vendor 1 table, Vendor 2 table, etc...And in each table list all of the parts along with order quantities specific to each vendor in the vendor table...Example...Vendor 1 from the Vendors table will have its own table with all of its parts listed...When I click add new order, I want the vendors information that is stored in it's record in the Vendor's table to pre-populate so that I don't have to pick the specific vendor every time...So that when I save the order, it will generate an email to the correct vendor...I know I could set it up to have to select the vendor every time, but I want to avoid the possible mis selection that could occur. Help! Thanks in advance!
Then you should have a Purchase Order Table and an Purchase Order Lines Table. One Purchase Order has many Purchase Order Lines.
Then also 1 Part has many Purchase Order Lines.
Presumably you will have chosen a vendor at the top of the Purchase Order. You can carry that field down to the Order Lines Table as a lookup and call it [Record ID# of Related Vendor].
When you set up the selection of the Part on each Purchase Order Line there will be a setting on the field property on the Related Part which is a checkbox to make this field conditional. Set that to say
after the field [Record ID# of Related Vendor] is selected
only shows parts where [Record ID# of Related Vendor] = the value in the field [Related vendor]
You may need to show that [Record ID# of Related Vendor] on the form for the list to filter correctly.
Here is some help on Conditional drop down.
Trust me, this is the way to go as having separate tables for each vendor will be a huge quadruplicate work and not scaleable to add a new vendor.
Hand entering multiple email addresses into the will not work. There is no delimited that will work. Not sure why.
But fear not ...
The vendor record should be set up with a field named like [Vendor email] and look that up down to the Purchase Order record.. You can also set up an email address in a field called [Office email address] as a formula email field with the formula
Then in your Open Notification, in the box for the email addresses, enter the two fields vertically by hand like this
[Office email address]
Note that you only need 1 email Notification set up - not 4 of them, as it will know from that field who to email.
They don't have to be vertical like that, but I think it adds to readability.