Newbie Questions

Re: populate a table-type form based on database entry ( hard to explain )

bitly — Mon, 20 Apr 2009 04:03:12 GMT

sounds interesting ill have to fiddle with it a little im still so new im not really sure what all that is but ill have to give it a shot!

Re: populate a table-type form based on database entry ( hard to explain )

Hilary Stoupa — Mon, 20 Apr 2009 00:58:23 GMT

So this would be another view in the same form that you use to submit the data to the database? You can add another query data connection in your form that queries the database where you are storing all your leave data. Then, for each of your leave types, you can add a repeating table bound to that data source. Filter each table according to leave type using table filters or conditional formatting.

Re: populate a table-type form based on database entry ( hard to explain )

bitly — Sat, 18 Apr 2009 04:14:41 GMT

ehh it cut half my table off...but you should still be able to get the idea...

populate a table-type form based on database entry ( hard to explain )

bitly — Sat, 18 Apr 2009 04:13:30 GMT

what ive done is made a database with the fields i want and a form to submit and query data to and from that database. simple enough right? eh maybe for some but a new challange has slapped me. im trying to make a table kinda like the one i attached made in infopath as a second view and to auto populate based on entry's made from the primary form. or from the database which is where it all gets submitted anyhow. if you need more information id be happy to try and add more. but if you get the idea of what im talking about ...then any help is appreciated :) below is a preview kinda quickly made up but almost like this. the fields below the leave type is what im looking to have auto populated..based on the leave type. so i put in all the info in my form and select from drop down menu the leave type and it auto fills the slots under the leave type on the example below.


PASS AND LEAVE TRACKER
RANK	LAST NAME		FIRST NAME		START LEAVE		END LEAVE

ORDINARY LEAVE
PFC	BLOW	JOE		14-Aug-09		23-Aug-09
SPC	DOE	JOHN		15-Sep-09		22-Sep-09

EMERGENCY LEAVE
SSG	KIRK	CAPTAIN		23-May-09		29-May-09

TRANS
SFC	RANGE	ON THE		23-May-09		25-May-09


CONV LEAVE