N
Nick Monsour
Hi all,
I thought I sent this in yesterday but I don't see it so here goes...
I have a SQL data source that I want to read data from and then write
to. A good example is a table that holds records for an employee. I
have employees that have access to different systems and databases.
Well sometimes employees transfer or get promoted and their records
need to be updated. I also have the restriction that none of the old
records can be deleted. I want to create a form that will allow me to
update the current records by adding a date in a "removed" field (easy,
got that) and I want to display new empty repeating tables to add more
records to that persons profile. I see the problem of when you run a
query to show what the employee already has all of the fields populate
with their information so I need some to show up with out the query
information. Any ideas how I can accomplish this?
Thank you,
Nick
I thought I sent this in yesterday but I don't see it so here goes...
I have a SQL data source that I want to read data from and then write
to. A good example is a table that holds records for an employee. I
have employees that have access to different systems and databases.
Well sometimes employees transfer or get promoted and their records
need to be updated. I also have the restriction that none of the old
records can be deleted. I want to create a form that will allow me to
update the current records by adding a date in a "removed" field (easy,
got that) and I want to display new empty repeating tables to add more
records to that persons profile. I see the problem of when you run a
query to show what the employee already has all of the fields populate
with their information so I need some to show up with out the query
information. Any ideas how I can accomplish this?
Thank you,
Nick