> middle of creating a new Coldfusion application that was
> originally written with Access Forms and has lots of
> subforms on many tabs. I've created all the subforms as
> separate pages (for now) and they're linked to the
> appropriate tables via the relationships and are pulling
> data.
> However,(and excuse my ignorance here), if I'm on a
> Coldfusion page (that's really equivalent to a subform)
> and add a new record on that page, will it add the record
> and keep the relationship?
> Secondly, what's the best way to emulate the subform
> behavior with Coldfusion?
> Thanks!
I've never worked with sub-forms in Access, but there are a couple of
tools available for developing tabset interfaces with ColdFusion if
you'd like to get them all on a single cf page... there's one in the
onTap framework and someone on this list posted another less involved
on using custom tags recently.
As to the relationships... your ColdFusion code is really and
genuinely completely separated from your Access database. There is no
connection whatsoever between anything on your CF page and your Access
DB, with the exception of your cfquery tags (and optionally cfinsert
and cfupdate although I don't recommend these). So if you want to
maintain a relationship between tables in an Access database, you make
sure that your CF code will always maintain that relationship by
carefully monitoring those relationships in the Access DB and
logically protecting them in your code. Creating foreign-key
relationships in Access (imo a hideous excercize in frustration) will
ensure the relational integrity of the database internally, and so is
your best defense against bad data. With these in place, the
ColdFusion server will produce a database error if a query attempts to
violate a foreign key relationship. The error may not be pretty, but
it will inform you when there is a problem in the code that you need
to fix.
hth
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
