InfoPath Dev

Hi Hilary, I have been away for a couple of days. I use the same field in six of the 6 of the 7 tables, the field is intended to be my key field. The tables have a 1 to 1 relationship. The seventh table has a separate relationship with the master table. These tables have a 1 to many relationship. I have now set up key field and tried to ...

I have still to get back to that issue. But as  a thought :::- When I use Drop down boxes, I use numbers as the value, text as the display. When you convert to an expression box, on a Print View, only the number value appears. But, if you think a copy of a Print View into another Print View holds the display text that is great. Can ...

I'll keep a copy of your code for future use. I am avoiding code as much as possible.  The code I wrote at the top is a default value box on the data window. I seemed to get it to work last week.  But today, the system seems to be screwing up the formula. I'll worry about it later. I have other problems. I had field ...

Thanks Swathip.  But the problem is (was) growing. Now I seem to not be able to submit to database.  Please refer to the last post on the Newbie thread.  By Patrick Halstead.    Subject:- "The system will not allow me to submit"   My issue is submit to a compute rAccess database. That is the problem ...

Hi Patrick, I designed the databases from scratch using MS Access. I don't know how to use XML. Each time I change the db, I do a Modify "Tools\Data Connection". For a week now, I have one table, as the primary table, all the other 6 are directly subordinate to it. I didn't cascade them, I could not see if that would ...

  Yes, Every time I change the database.  I leanrt that early in my trials with IP. Likewise Checking the checkbox on the bottom of the InfoPath create  screen. I have had trouble for the last 2 days trying to get valid field connections.  I kept getting unbound warnings.  I have used the initial form template and added ...

After days of reorganising and rebuilding the form, for the large table down to 7 small tables, I find the InfoPath system will not allow me to Submit. It advises that I am not permitted the use Submit, because of my data structure. I start with one table into Data Connection. I use that table because it is part of the key ...

I am getting repeat sections added to the data section on the form.  All I want is to have a single record referenced when I added a field (which may now come from any one of 7 tables) to data section in the IP form.  At the moment when I drag a field over, it automatically assumes a repeat section.  What can I do to correct ...

A default seems to be that if a key field is blank, and the Query button selected. Then all records are displayed. If a value is entered for a key field, only that record is displayed. The Problem is :-  If I have 2 key fields, each one a field from a separate table. I enter a value for the second field. All records are displayed for ...

I had 1 large Access database. And one InfPath Form using that database. All seemed okay. Until Access spat the dummy and would not allow me to maintain the DB.   I was advised to split the table up into smaller ones. I did so. And now have 7 small Access tables, averaging about 40 fields per table. The problem is.  I am trying to ...