mhemans

I appreciate the answer and suggestion. That did the trick.

I have two databases. They have been set up with a relation based on a unique serial number. When I type in the serial number or serial numbers (separated by a carriage return) into the number field in database "A", it gives me a list of colors from database "B". Some of the colors for each serial number may be the same. Currently, I am getting a list of colors that are duplicates (ie: Blue, Blue, Red, Blue, Yellow). I want a field that simplifies/consolidates the list of text to just one of each (Blue, Red, Yellow). How do I go about this?

It fails by not doing any of the steps. They are both date fields. Thanks for the comment about a single record. I will work on getting it look at all records.

Need a little help with this script. I have two date fields. One enters the date once another fields is marked as reviewed. The other pulls in the last date from a report via a portal. As things get revised via the portal, I wanted previous fields to be reviewed based on the fact that there was a revision created. So I have if the date revised > than the date reviewed. If true, then I want it to clear a couple of fields so that I know that I need to review it again. The script as is, is not working. I am clearly missing something and the answer is probably sitting right in front of me. Any help would be great.

I have a brand new database that I will be sharing on the network using FM 12 Server Advanced and Instant Web Publishing. This new database will bring in data from 4 different databases to be viewed in one record of this new database. Some of this data brings in 4 different container fields. Three of them are brought into a field in this new database via a calculation (If (isValid…). The last is a showing data via a relationship that I set up. All currently show up fine via IWP. I would like to make them all referenced fields to keep speeds up and also so that this new database is updated in the background while data is modified in the other databases. If more info is needed, let me know. I was trying not to get too wordy.

I have two databases that I can easily relate to a third with a common field. This allows me to key in data in the third and have some of the data show in the other two databases, which keeps me from entering common data multiple times. However, I want to create a record in the third database and simultaneously create a record in the first or second database that includes a copy & paste of the common field, which happens to be a serial number. I can do this with a table, but prefer to keep DB 1 & 2 separate from 3 as DBB 1 & 2 are shared by different groups of people via Instant Web Publishing. How can I do this?

Is it possible to have a database that is shared via IWP allow users that connect via this access point to export to an excel file?

thanks to all. I will give it a try and let you know.

What is preventing me from doing what I am thinking? Just curious.

Well, I have an item # that is in both tables. I currently have a relationship set-up using that # between table 1 and 2. Table 1 has the item # and all of its components/parts. Any time the item is revised a new record is created in table 1. I want to use table 2 to show the item # at the top and use a portal to give me a summary of table 1 below. Since new parts are given to me in an excel spreadsheet and I import them into the db via table 1. I can even get the first item/row into table 2 from the import. If the spreadsheet has more than one row of data, it will import fine into table 1, but stops after 1 row in table 2. I should add that my import occurs with a script to keep mapping of the fields in the proper order. I also thought that I could tack something on to the script that will allow me to add the extra records into table 2. If the item # is revised I have a script that duplicates a copy of the matching item # via the portal and I change any data that I need. In the end, I only want to look at table 2 and see a history of that item # via the portal. The only hang-up I have is that I need to manually add the new record in table 2 and add the item # from spreadsheets with rows below line 1. Hope that helps.

What are you perplexed about? Maybe I can elaborate on something.

Currently I am creating the record in table 2 manually, type in the the fields that contain relationships and the remaining fields populate themselves via the relationship. I should also mention that table 2 is the main layout that I am viewing and am trying to work my way from table 1 because table 2 give me a comprehensive look at the data. Define "foreign key". I have tried the set field and it does not work as part of my import script. But creating a script that contains copies and pastes between the two tables does, but it only gets the first row of data from the spreadsheet. I want all the rows that are on the spreadsheet not only import into table 1 (they do import into table 1 just fine), but table 2 as well w/o doing two separate tasks. When the data exists in table 2 and I want to add to table 1 I have a script/button in the portal of table 2 to create a new entry in table one. I am not sure how to answer the last question.

Where's the red flag? All that I am trying to do is make a script. I have a script that allows me to import data into my db and have the field's pre-mapped and now I want to expand on it and copy a couple of fields into a second table. I only need this for items that I import. Right now I am manually entering into table 2. If I make a revision, I do it my duplicating the record in table 1 and editing the data that is changing The two tables have a relationship based on a number. The first table acts as a log of all items regardless of number and that number can be in there more than once. The second only has the number in there once and shows the history from table 1 based on the number.

I have a db with two tables. I import into one table from an excel spreadsheet, with multiple rows of data. That works just fine, but want to create a new record in the second table and copy specific fields to it. The 2nd table also has portal for the records in table 1. I can get the first record created in table 2 but does not create the remaining rows/records from table 1. Help please!

I have a db, with three tables. Two of the tables have data in them that get used by two different departments. I have the third table to give me a summary of the two other tables. The issue I have is that the first two tables have a notes field that I want to merge in the third. I know how to add characters or spaces to separate things, but in this case I want to add a carriage return. How do I go about that.

Is there a way that I can have a field to automatically format? i.e. have a phone # go from an entry of 10 digits to (xxx) xxx-xxxx.

Thanks. I created a test file, and it works great. However if I export the data to excel, only the error from the first "error" field shows up. Any thoughts on this?

Are you suggesting that I have a field shown, say 3 times, and have a different value list for each? (Field=Error w/value list 1; Field=Error w/value list 2; Field=Error w/value list 3).

Is it possible to create Header's and Sub-headers within a value list, while using the checkbox feature? I don't want the Headers to have a checkbox next to them either.

I have a database that has a few layouts. Right now I have a button with a script attached to it that allows a copy of three of the layouts to print to one printer. I would like to change the script and have one of the layouts print to a second printer. I am trying to automate the process as much as possible without having to choose the printer or create two buttons. Is that possible? If so, How? Thanks, Mark

The only thing that it seems to do is create empty fields. Maybe I need to rephrase the question. I have database A & database B. Database A has two number fields, a field for a customer name and 2 fields for parts. One of the numbers refers to one part and the other number to the other part. In Database B, I have a field for one of number fields, the customer name field, and 1 part field. Database B is one that another department is using and I want them to be able to enter a number in the number field, and have the remaining fields populated. The thing that I am having trouble with is, I can get one of them to work (entering in part #1 gives me customer name and part name). When I enter the number for part 2, I don't get anything. Thanks

I am having some difficulty with a new db that I am creating. I have created a relationship in the new DB with an existing DB. The problem that I am having is that the existing DB has two fields that I am trying to relate to 1 in the new DB. First, is it possible? Second, if it is, How do I go about it? Thanks.

for example: field 1 = blue, Field 2 = red, Field 3 = pink with a result of dark purple

Anything special to add 3 fields and one result?

I am looking to create a calculation with a result that is based on 2 different text fields. For example: field one contains "Blue" and field two contains "Red", I want to show a result of "purple". Any suggestions?