> > If one has an input form that is split into two sections, one for
> > the 'requester' and one for the 'respondee', is it better to
> > create two tables, one for each 'section' with access rights on a
> > per table level, or create a single table and with access rights
> > restricted on a field by field basis (if this is indeed possible)?
> Not quite sure what you are trying to achieve here. The respondee
> needs to be able to write to fields to reply? So would need full
> access and the requester would need to see the replies. In any case,
> VIEW could be used for a reduced set of fields.

How separate are the processes? Can two requests be anwered by one
response or one request require zero or multiple responses? If so, I'd
go for separate tables (two or three), if not Lesters VIEW solution is
good.

> > Any suggestions for a 'Grant Manager' program for use with FB?
> I use the grant manager in IBOConsole.

And I use Database Workbench. Though Database Workbench is a lot more
than a grant manager, and I don't think it is worth the price if you
only intend to use it for grants.

HTH,
Set