Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Bonnerbl

  • Rank
  1. Unfortunately the pdf aproach won't work because of the quality of the output when printed from a pdf rather than directly to the printer.
  2. My report consists of many sliding fields so each record may result in one to many pages of text. I am printing duplex. Each time it starts printing a new record I need to make sure that it is on an odd page. Can someone point me in the right direction?
  3. Can't figure out what is happening. I have a value list with values A, B, and C. The field definition in the table says this field is always validated and the values must come from the value list. The entry field on the screen says it come from a drop down list based on the same value list. When the user clicks in that field, the three choices appear as they should. If the user initially clicks on B, the field is filled in with A. If the user initially clicks on C, the field is filled in with B. In either case if the user returns to the field and again select B the field is cor
  4. They contain text. For example: "Shreve 1920" or "None" or "Pastel". (I had no hand in the database design. Have to work with what I've got :->)
  5. I am importing data from an older version of the database. Unfortunately when the new database was created it used the same field for what were in the old database several fields. For example what was in old data::mark, old date::engraving, or old data::illustrated imports to one new field::model. The difference is if the record is type A then mark imports to model, if the record is type B then engraving imports to model,and if the record is type C then illustrated=model. So I need to do an import and as each record is imported, inspect it for a type, and then do the appropriate im
  6. Interesting. Unfortunately this is PC shop.
  7. Need help figuring out this problem. I have two reports. Report #1 is a simple report layout and the user uses the default Filemaker PREVIEW and then PRINT and/or PRINT SETUP to choose the printer and options. Report #2 on the other hand is printed from a script. The script contains a Print Setup - performed with a dialog and no page setup options chosen. It then later on does a Print[No dialog] without any print options specified. If I print report #1 and click on the PRINT icon in the FM toolbar and send it to printera and then print report #2 but choose printerb in my script
  8. What was missing was a go to field step before going to the portal row. I hadn't mentioned in my post that there was more than one portal on the layout. So #1 added the commit, #2 added the go to field. Works fine now.
  9. Nope. Still not working. The first time I run the script I get portal rows as I expect. The next time I run the script it is not creating a second row. Looks like it is updating the existing row.
  10. The problem isn't that it doesn't find the portal it does. It does add the portal row. The problem is that if you run the script again it doesn't add a second row. It seems to replace the values in the first row.
  11. hmmm. 85 views and no reply. This is what I think will work. 1. create an empty "conversion" database with table identical to the old database. 2. in the new database the script should - ask the user for the name of the database to be converted. - copy that database into the "conversion database" - import from the "conversion" database. My reasoning is that if I have a "conversion" database I can identify it in the script and the import mapping step will display its fields as well as the new database fields. That solves my problem of identifying to the import mapping what
  12. Item table has a historical values table. There can be multiple historical values per item. The relationships is defined that historical values can be deleted/created/etc from the item. I have a script to update the historical values with current info from the item table. What is happening is that it seems to be overlaying the existing portal row rather than creating another one. Freeze window Go to layout [item layout with the history portal in it] show all records go to record/request/page [first] loop go to portal row [last] set field [historical::value; item::value]
  13. This is similar to 3217167 Importing from old copies of the same database. I have database A developed several years ago. There is now database B with new tables and some similar fields but with different names. I need an automated way to import the old informtion into the new database. I I am now at the point of using the IMPORT command to import. Part of that is the mapping of the old fields to the new fields. But when I go the screen where I indicate the mapping, the source table/fields naturally are not there. 1. How do I specify the mapping if the screen doesn't know what t
  14. Iam on F10 and FM11. Have a table of contacts. For various reasons these contacts may be related to one another. I created a relationship table that contains the record id of a contact and the record id of the related contact and the type of relationship. When a user is viewing a contact they have a portal they can use to establish a relationship with another contact. The issue is that users know about the name of a contact but not the record id of a contact. I want the user to be able to go to the portal, scroll through the list of existing contacts, select one, specify the type of relat
  15. Thank you for the correction to mfero's post. You both told me exactly what I needed. If you read my post again you will see that the reason I needed to create the B records now was that the B table was added to a database that already had records in the A table. Going forward there wouldn't be any problem because B would be created automatically. The essense of my problem was that A records already existed before table B was created.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.